I am trying to insert an array into SQL with no luck. I get the string from a GPRS device that looks like this:
/WeightBridge.aspx?ReadeID=A1B5A0F5C4E4A1B5A0F5C4E4&TagID=45B6C56A90B645B6C56A90B6,A47B1256A45F0843,B49B1256A45F08FF,30 SEP 2010 21:33:59,I,&Custom=Vehicle Num
All I want to do is to split the TagID array and insert it with the rest of the string into a SQL table. The TagID array must inserted into the following colomns in the DB. TagID, TID, UserMemory, DateTime and Direction. After the insert I just give a response that the insert was successfull or failed. Thank you
I am selecting data from database and in while loop, i want it store all data in one variable. How to do that? The variable selectAnswer is string array type .
I used this code but this give error. Modify this code.
string selectAnswer[] = new string[]; while (rdr.Read()) { selectAnswer[] = rdr[0].ToString(); }
I have a query string which contains the value of more than one Array, I want to pass these values from Page 1 to Page 2 and then distribute the array values into new arrays on Page 2.
Here is what I have so far.
Page 1
[Code]....
[Code]....
Page 2
[Code]....
All that I get returned in EFFinal and IFFinal is System.String?
I have a stored procedure that is close to working. It takes the values of a details view puts them into the respective table 'entity' then should also put the @@identity into 'entloan' and should put the LoanID which is in the query string of the page the detials view is loaded on, into the LoanID field of entLoan as well. Everything works except for getting the querystring value to pass to a insert variable on my stored procedure.
Stored Procedure
[Code]....
I do not have a LoanID Insert parameter set as it is not in entity table:
[Code]....
I have been playing around with different code in the backend but always get errors:
Without going into the background, I'm building a table by hand which will become the datasource for a gridview. I'm trying to insert a line break and neither of the following works:
I am trying to insert a array into SQL with no luck. I get the string from a GPRS device that looks like this:
/WeightBridge.aspx?ReadeID=A1B5A0F5C4E4A1B5A0F5C4E4& agID=45B6C56A90B645B6C56A90B6,A47B1256A45F0843,B49B1256A45F08FF,30 SEP 2010 21:33:59,I,&Custom=Vehicle Num
All I want to do is to split the TagID array and insert it with the rest of the string into a SQL table. The TagID array must inserted into the following colomns in the DB. TagID, TID, UserMemory, DateTime and Direction. After the insert I just give a response that the insert was successfull or failed.
My code this far:
Imports System.Data.Sql Imports System.Data.SqlClient Partial Class WeightBridge Inherits System.Web.UI.Page
I ve design a page that has nine text box name txtSubject1 to txtSubject9 with the visibile properties to be false.I now have a method called Save1, Save2 to Save9 depending on the no of subject selected from the dropdown.But i think that is not professional bellow is a sample of how i did't and i believe the textbox can n number of an array that can be selected from the drop down. i need someone to put me through how to insert this into the database out side the fake method i ve used.
We are sending an HTML encoded string in the Query string. It was working fine on IIS 6 (windows 2003). We have recently moved the website to Windows 2008 (IIS 7.x). Since the move any Query String that contains "+" sign i.e., "%2b" gives error on the server "404 -File or directory not found."
I have a problem with assigning string array into Datarow. Firstly, i have created the object for string array and put 2 values in the array out of 100(whole size). How many values should be placed in the array dependds on a different, which i am not showing here, though.
Then i tried converting into DataRow. But it says. "object reference not set to an instance of an object"
DataRow dr = null; string[] strconcat = new string[100]; dr["concat"] = strconcat[i];
Edit-- Actually i was trying put these string array values into dropdown (ddchooseadeal).