[code]...
What would be wrong in the above code. ExecuteReader is throwing excepion. Invalid cast from string to GUID. But My Sqlparamter was already uniqueidentifier nothing cast.[code]...
[Code]...
how can i get this code to return all values instead of just the first value ?
im workin on a task that will get the current computers Default Gatway, So i chose the easiest option, using the Registry, in most cases i find this with no problem at all, here's the code im using right now,
Public sHost As String = My.Computer.Registry.GetValue _
("HKEY_LOCAL_MACHINESYSTEMControlSet001servicesTcpipParametersInterfaces THE GUID NEEDED HERE ", "DhcpServer", Nothing)
Which works fine, if i put My GUID in where i've stated in above code, I get the right value ect..., no what i was woundering is how would i get the program to preform this task on another Computer as their GUID will be diffrent, if their away i can do this with simplicity?
i have create a procedure to return data reader value, but it not return and returning null reference?
'Public Shared Sub GetData(ByVal Tablename As String, ByVal queryfield As String, ByVal Id As String, ByVal lblmsg As Label)
' Try
' Dim Cons As OleDb.OleDbConnection = DBHelper.GetConnection
' Dim Com As OleDb.OleDbCommand = New OleDb.OleDbCommand("Select * FROM [" & Tablename & "] WHERE [" & queryfield & "]=" & Val(Id), Cons)
[code]....
I have a table in my database and I want to return the rows in a data reader and retrieve them in variables. I can do that well but I can only return the last record. The reader doesn't process all the rows.
Try
Dim myconecction As String
myconecction = My.Settings.DataSource
[Code]......
Using VB.Net and C#.Net
Using 3 Tier, I was executing this query in DataAccessLayer, i want to call this query in ApplicationLayer throgh BUsinessLogicLayer.
Code.
Cmd = New SqlCommand("Exec delTable", con)
cmd.ExecuteNonQuery
I want to return this execute command like this,
In application Layer How to call this?
I've a procedure like this:
[Code]...
[code]...
Someone can tell me why the VB pass for the if marked by bold and don't execute them????
How can I execute a stored procedure using sqldatasource and get the return value in vb.net.
View 2 RepliesI was rooting around in one of our company apps which is done in VB.net. I'm not familiar with VB.net (I do stuff in C#) so I'm asking this question: Does the code after the clean up comment execute? [code]It is my understanding once you say return, you give the calling function control again.
View 6 RepliesI want to retrieve total value from sales table in sqlcommand object. Below is my sample code.I will get error if there was no data in the tabel that matched my query saying that null could not be converted into decimal.
I would not get error if there was data that matched my query and returned the total value in tmpSales variable.My question is what is the best way to deal with this situation?
Dim CmdTmp As System.Data.SqlClient.SqlCommand
Dim tmpSales As Decimal
CmdSales = New System.Data.SqlClient.SqlCommand("SELECT SUM(Total) FROM Sales WHERE Date>= '1 Jan 2011' And Date<= '30 Jan 2011", ConDB)tmpSales = CmdSales.ExecuteScalar
I have some VB code like
Dim data As DataTable = DataAccess.ExecuteDataSet("AuthenticateWebServiceClient" _
, New SqlParameter("@ClientID", ClientId) _
, New SqlParameter("@Password", Password) _[code]....
Except PrepareSPCommand isn't recognized by VS. Does anyone know the correct way to convert this function to C#.
I am trying to retrieve values from a stored procedure using plsql at backend with vb.net. Its a desktop application. In my crystal report I added a pie-chart . There are two columns in my db table and pie-chart is to show the values of one of the column against values of another column. But when I run the application I get error " Invalid Parameter Number". I'v set 'On change of ' in chart expert to one column and 'show values' have the other column .
View 1 RepliesI 'm new to programming and to vb. So my question could be from misconception about what can i do. How can i pass a string to a "procedure" and get in return a object whith the same name as the string?
View 8 RepliesI would like the focus to pass from TextBox1 to TextBox2 when I press the Return Key.
View 4 RepliesI'm trying to take a resultset, store in a class then retrieve the complete record for a given value. For example, the recordset has AnalystID (Unique), LastName, FirstName. I want to be able to pass the AnalystID and return the name. I need the ability to look up either last or firstname by analystID throughout the program. Here's what I have so far. I'm not sure I'm even headed in the right direction.
[Code]...
I have an error that is during the query to a database ExecuteReader 'phase' of my program, i am assigning an .OleDbDataReader to a variable RetVal and then, i am giving this RetVal = Query.ExecuteReader, and then in the while the query is being read loop(While RetVal.Read) i am getting an error in runtime that is "Invalid attempt to call Read when reader is closed." I know this means i have to open the reader, but i don't know how to do this, as i have been using this process for a few weeks and haven't had this error pop up. (and i have managed to use the while loop)If you're not living on the edge, you're taking up too much room
View 7 RepliesTrying to find some code to assist with accessing a web service. I am a newbie when it comes to web services and don't quite get the whole how to submit the request and then read the results. I know from searches that people request a copy of the WSDL file so I have attached (SystemManagementService.wsdl)
[Code]...
Is there a way i can execute a CLI program and have it output or return what the CLI program sais, such as ping etc.
View 3 RepliesI want to launch a application called Foxit Reader pdf Reader .I know System.Diagnostics.Process.Start(path) can do it but . Requirements are Foxit Reader should be installed on machine.Now if it is installed how to serarch for the path of its Executable to provide the parameter as I can not hardcode the path for different machines.
View 3 RepliesI am having an issue with both Adobe Reader and FoxIt Reader when trying to print a PDF document. Both issues are different but a solution to either one will allow me to fix my issue.The issue I am having with Adobe Reader when trying to print using the following code is that it will not print it to the network printer I specify but just the default printer.
Dim AdobeReader As New Process
AdobeReader.StartInfo.CreateNoWindow = False
AdobeReader.StartInfo.Verb = "print"
[code].....
how would I accomplish saving a large piece of data, using the Stream Reader for the Line-by-Line, while keeping the carriage return line feeds in there?
[Code]...
Is GUID really unique? I have a webservice that the client application connects to, which generates a GUID. I know GUID are generated using the mac adress of the NIC. Is the NIC in the webservice server used or the client NIC?
View 1 RepliesI need to specify a GUID for each event declared in my class, to be able to generate a manifest for it.
Right now i'm decorating the class with the following:
ComClass("AB849263-E1F7-466B-9BAC-828E67F2871D", "EB2AB5A4-D3AD-4C01-81FB-A73AB0B3848C", "6623B1F2-2D4E-4974-AE51-369F65D47F69")
However when i use the MT tool to generate the manifest, i'm greeted with : "mt.exe : genman warning G81010014: Explicit guid not defined for type NetTest.NetClass+TestEventHandler."
I am building a User Management section to a website CMS.The user has a list of users and then clicks the edit button, the system then stored the UserId in a session and goes to the editUser.aspx page which will show the users details.To get the users details I need to convert the UserId session to a Guid so i can get user details.
I keep getting error message:
System.InvalidCastException: Specified cast is not valid.
Dim selectedUserId As Guid = CType(Session("strUserId"), Guid)
Dim mu As MembershipUser = Membership.GetUser(selectedUserId)
I have an external database that is feeding information to me. One saves their data as native GUID format and my other data source supplies standard .NET GUID format string. Is there a tidy way to convert from Native GUID to GUID Structure? Also is there any validation bit to determine if a provided value is a Native GUID or not? I can't seem to find any if there is one. The difference is as follows:
typedef struct _GUID
{
DWORD Data1;
WORD Data2;
WORD Data3;
BYTE Data4[8];
} GUID;
Data1, Data2 and Data3 get their byte order reversed but Data4 remains the same, see [url] for more info.
I have multiple applications that will be calling a DLL.Is there a way to get the GUID from the calling application without passing it?I would like to use the GUID to verify the parent application and open up rights within the DLL for a specific app but not others.
View 3 RepliesNow i am doing a vb.net desktop application, In which i have to construct GUID. Eventhough having a built-in function in our VB.NET like "System.Guid.NewGuid.ToString()" to get GUID, I need to create the GUID in 30 digits in the below mentioned criteria through vb.net.
Application constructs the GUID (30 digits) using the information from the 5 different sources. The different sources are Current system time, millisecond of the system time, Process ID for the application, system physical memory status and finally the group object identifier number.
8 digits
4 digits 8 digits
8 digits 2 digits
[Code]....
I am not sure how to get the above values to construct the GUID?
We have a .NET app that needs to examine a folder that may contain COM libraries (DLL and OCX.) When we do encounter a COM library one thing we need to accomplish is to extract the GUID from the COM DLL or OCX.Is there a straightforward way to do this with .NET without using 3rd party libraries?
View 3 RepliesI'm calling a GUID with a system function and trying to insert it into a database as a primary key. i'm using vb 2010 .net framework with sqlce server making my datatables. the column is AutoNumber which i set up to be a uniqueidentifier. the length is not adjustable and set at 16. i got all kinds of not parsing query errors. i've edited the insert statement a bunch trying to figure this out. i've went so far as changing the table schema of AutoNumber to be just a nvarchar with length of 100. it's something to do with how i'm inserting the GUID. in the code below i'm converting it into a string then inserting it into my table. is this wrong?? i've tried finding other ways of doing it but it's a little confusing. everything else in the code works perfectly it's just this part that is keeping me from completion.[code]...
View 2 Replies
