Saving to a database

<edit by Frinavale>
Removed the quoted .NET article on how to use a database in your program
</edit>
PLS HELP!
I Have been able to do all the above successfully though for my own code(C#), i'm retreiving the parameters from the user's input i.e. a login form. when i run this code it saves nothing to the database and it generates no errors.so i dont know where i've gone wrong.
i put the following code in the onclick eventhandler of the login button but it still doesnt work. can u help me?

Expand|Select|Wrap|Line Numbers

1.  public void login1_Click(object sender, EventArgs e) 
2.         { 
3.  
4.  
5. addstudentinfo.InsertParameters["Surname"].DefaultValue = 
6.                     TextBox1.Text.ToString(); 
7.                 addstudentinfo.InsertParameters["Names"].DefaultValue 
8. = 
9.                     TextBox2.Text.ToString(); 
10.                 addstudentinfo.InsertParameters["Regno"].DefaultValue 
11. = 
12.                     TextBox3.Text.ToString(); 
13.             }

Hi Mercea,

I have split your question off of the "how to use a database in your program" article and have moved it to the .NET Forum. In the future please post your questions here (blue menu: Forum-> .NET). Thanks.

Looking at your button click code I'm not seeing any sort of database manipulation. Could you please post the code that is causing the problem so that we can help you better.

Cheers!

-Frinny

thanks.
the code above is the code on the login page.
the code for the gridview page is

The gridview gets its data from an sqldatasource whose select and insert statements have been defined

Are you ever calling the Insert() fnuction?
http://msdn2.microsoft.com/en-us/lib...rt(VS.80).aspx

My help said that you have to call that in order to run your insertcommand

Hi Mercea,

I think i know what is happening.
Currently you are setting your GridView's data source in the Page_Load() function like so:
Because of this your GridView's data source is reset every time your user posts back.
If you do this, then your edit details will be over written with the data from your database and the user input values during editing will be lost.

You should only do this when it is not postback or if any changes have been made so to refresh your GridView.

Try changing your code to this:
Hopefully this solves your problem :)

-Frinny

Hi Mercea,

I think i know what is happening.
Currently you are setting your GridView's data source in the Page_Load() function like so:

Expand|Select|Wrap|Line Numbers

1. protected void Page_Load(object sender, EventArgs e) {
2.         SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=engineering; Integrated Security=True");
3.         SqlCommand cmnd = new SqlCommand("SELECT * FROM test101",conn);
4.             conn.Open();          
5.            GridView1.DataSource = cmnd.ExecuteReader();
6.             GridView1.DataBind();
7.             conn.Close();
8.     }
9.  

Because of this your GridView's data source is reset every time your user posts back.
If you do this, then your edit details will be over written with the data from your database and the user input values during editing will be lost.

You should only do this when it is not postback or if any changes have been made so to refresh your GridView.

Try changing your code to this:

Expand|Select|Wrap|Line Numbers

1. protected void Page_Load(object sender, EventArgs e) {
2.        If (IsPostBack == False)
3.        {
4.              SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=engineering; Integrated Security=True");
5.              SqlCommand cmnd = new SqlCommand("SELECT * FROM test101",conn);
6.               conn.Open();          
7.               GridView1.DataSource = cmnd.ExecuteReader();
8.               GridView1.DataBind();
9.               conn.Close();
10.        } 
11.     }
12.  

Hopefully this solves your problem :)

-Frinny

hi,
thanks for replying but it still does not save any data to the database. the gridview page comes up blank and does not even display the emptydatatemplate as before. any more suggestions?

Did you ever call the insert function?

Did you ever call the insert function?

anytime i called an insert function i.e. addstudentinfo.Insert(), when i try to run it, it gives an error "must declare scalar variable @TextBox1"
and i have declared my variables. when configuring my datasource and calling the insertparameters functions. So i took it out

Well your inserts will never happen without calling the insert().
That bit of info would have been usefull awhile ago. There is something wrong with sql command string (it's never getting a value for that varriable)

Work on fixing that and see what else it fixes.

Well your inserts will never happen without calling the insert().
That bit of info would have been usefull awhile ago. There is something wrong with sql command string (it's never getting a value for that varriable)

Work on fixing that and see what else it fixes.

sorry for leaving out that important piece of information.
pls would u mind taking a look at code and just pointing me to were i've missed it? cos i dont know were i've gone wrong or wat i've missed
This is for configuration of the sqldatasource
this is for the gridview
the C# code is as above.
i'm sure i've missed it somewhere.
thanks

Well take a look at these:
Your insert command uses "Textbox1" (and 2 and 3)
Then your insert parameters have ControlID="TextBox1" and then a DefaultValue="TextBox1.Text", that seems fishy. Like you have two controls with the id TextBox1 or something.
You should go through and try and give everything unique descriptive names.

Well take a look at these:

Expand|Select|Wrap|Line Numbers

1. asp:SqlDataSource ID="addstudentinfo" runat="server" InsertCommand="INSERT INTO test101(ID,Surname, Names,Regno) VALUES (@TextBox1, @TextBox2, @TextBox3)"
2.             ConnectionString="<%$ ConnectionStrings:engineeringConnectionString %>" ProviderName=System.Data.SqlClient >
3.  
4.                 <InsertParameters>
5.                     <asp:ControlParameter ControlID="TextBox1" DefaultValue="TextBox1.Text" Name="Surname"
6.  

Your insert command uses "Textbox1" (and 2 and 3)
Then your insert parameters have ControlID="TextBox1" and then a DefaultValue="TextBox1.Text", that seems fishy. Like you have two controls with the id TextBox1 or something.
You should go through and try and give everything unique descriptive names.

sorry to ask so many questions but i thought that since the variable is to be read from the first TextBox, whenever i'm referencing like in the insert command and setting the default value it i have to use its id(which is TextBox1). do u mean i should change the id of the textboxes all together?

To be honest I'm shooting in the dark here, I normally do everything in code and not as embeded objects in UI so I'm not familiar with their command structure.

It just seemed like you were naming possibly multiple things with the same ID and then your insert parameter couldn't find it for some reason.
So if you named everything something unique, you could see which one was causing the problem.

To be honest I'm shooting in the dark here

Now I understand why people are scared of the dark ;).

Now I understand why people are scared of the dark ;).

CAN U BRING US INTO THE LIGHT? COS THIS DARKNESS IS REALLY THICK :(

To be honest I'm shooting in the dark here, I normally do everything in code and not as embeded objects in UI so I'm not familiar with their command structure.

It just seemed like you were naming possibly multiple things with the same ID and then your insert parameter couldn't find it for some reason.
So if you named everything something unique, you could see which one was causing the problem.

I'm beginning to suspect that i've missed some fundamental concept here. so i want to review the basics with u if u dont mind:

-the data can be generated on page1.aspx and saved on page2.aspx right?

-the insert() method can be placed in the page1.aspx code and it'll save on page2 provided the gridview is configured for the datasource right?

-can i configure 2 gridviews on seperate pages with 1 datasource? i want one to be read-only and the other editable. is it possible?

-the datasource mode property is set to dataset. so am i to create a new object of the dataset or configuring the datasource and gridview takes care of all that?

-Is the above code not declaring the variables?
thanks...

-the data can be generated on page1.aspx and saved on page2.aspx right?

Actually, I suspect no? I don't think you can use the same object like on both pages?

Actually, I suspect no? I don't think you can use the same object like on both pages?

hi all,
thanks a lot for your input. i finally saw the problem. i took out the insert command and the Executenonquery() in the code-behind page and it worked!!

hi all,
thanks a lot for your input. i finally saw the problem. i took out the insert command and the Executenonquery() in the code-behind page and it worked!!

Awesome :)

Thanks for sharing the solution!