Good day!!!
can you help me with my code on whats wrong with it. I want to update my MSSQLSERVER database from a DataSet. and there's nothing happen with my
Database.
Here is my code:
string ConnString = "Data Source=localhos t\\sqlexpress;I nitial Catalog=dbSampl e;Integrated Security=SSPI";
string SelectData = "SELECT * FROM TblIndex";
int added = 0;...
k3nTm
Last Activity: Sep 24 '07, 04:26 PM
Joined: Sep 9 '07
Location:
-
Update Database using DataSet
-
Database to dataset
Is there a way to place the data from my sql server 2005 database to dataset randomly in a row. coz I have quiz engine and i want to display it in lablebox randomly form a dataset. -
Array to a DataSet
i just want to ask to anybody how to transfer the data in the array to a dataset in asp .net c#. -
thanks for the reply
I will place the data randomly to the data set after i will make a select query to
my database (sql 2005)
How to do it? coz I am still new to this.... -
place Data in DataSet randomly
please help me about my project. It is a simple Quiz engine that i can add questions as well as its answer. I will be using a data set. I would like that the questions will be place randomly to the data set or the questions would randomly
appear.
I am using Visual studio 2005 C#
I hope that you can help me thanks :-) -
just try this code
string ConnStrng = "Data Source=localhos t\\sqlexpress;I nitial Catalog=Members Account; Integrated Security=SSPI;" ;
string updateRec = "INSERT INTO TblMembers(Full Name, Iam, Email, Password, BirthMonth, BirthDay, BirthYear) VALUES (@FullName, @Iam, @Email, @Password, @BirthMonth, @BirthDay, @BirthYear)";
SqlConnection SqlConn = new SqlConnection(C onnStrng);
...Leave a comment:
-
HALO GOOD DAY
for your connection string use this code:
string ConnStrng = "Data Source=localhos t\\sqlexpress;I nitial Catalog=XXXXt; Integrated Security=SSPI;" ;
where: XXX is the name of your database....Leave a comment:
-
Thanks... :-)
but can you pls tell me what this code means
Dim Conn
Set Conn = Server.CreateOb ject("ADODB.Con nection")
and how to find ADOBD.Connectio n in VS2005...Leave a comment:
-
VB to C# MapPath
Halo I'm just new to asp .net...
I fill up free hosting site titanichost.com and I would like to make a connection
to the msaccess database and they give this connection to make
Dim Conn
Set Conn = Server.CreateOb ject("ADODB.Con nection")
strConnection = "DRIVER=Microso ft Access Driver(*.mdb);D BQ=" & Server.MapPath( "/USERNAME/db/yourdatabase.md b")
oConn.Open(strC onnection)...
No activity results to display
Leave a comment: