A Page in Asp.Net

Question

0.00/5 (No votes)

See more:

I am doing a final year project on music store in Asp.Net. But i don't know how to connect Asp.Net with Sqlserver(integrated sqlexpress in vs2008). So i need someone to help me by creating a asp.net page with a textbox and button. After entering a text into the texbox and clicking the button should create a table with name from textbox entry in database.
Please help me.
I think this will help me with the connection problems.

Posted 30-Dec-10 18:14pm

sharathu7

Updated 30-Dec-10 18:25pm

RaviRanjanKr

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ankur^\m/ · Accepted Answer · 2010-12-30T19:05:00

This is one of the very basic thing. I suggest you to spend sometime learning ASP.NET before you start the project.

I am saying this because even if I give you the code for your above requirement, I am sure you will come again and again with a new simple issue. You won't be able to complete the project in time.

So it's better to spend sometime understanding the basics and then start developing.

There are lots of tutorial available on the web. The best place to start is http://www.asp.net/[^].

Data-access tutorials can be found here: http://www.asp.net/data-access/tutorials[^]

You will find the answer for your above query here: http://www.w3schools.com/aspnet/aspnet_dbconnection.asp[^]

And last but not the least, take the maximum use of search engines like Google. Google is programmers best friend.
And for articles and tutorials CodeProject rocks. You can find anything and everything here.

I hope this helps.
Cheers!

TejuKrishna · Accepted Answer · 2010-12-30T18:37:00

Solution 1

Try Following query it will create table in database.
public void AddTopic(string _name)
{
string _sql = "Create Table Tbl" + _name + "(SrNo Varchar(40) Primary Key,Query NVarchar(max),TopicId Varchar(40) References TblTopics(TopicId),Description NVarchar(max),URL Varchar(500))";
DataHelper.ExecuteCommand(_sql);
}

Posted 30-Dec-10 18:37pm

TejuKrishna

Comments

sharathu7 31-Dec-10 0:50am

it will be helpful if u can upload a asp.net page with the one i asked. B'cos i dont know how to connect it with sqlexpress.

Ankur^\m/ 31-Dec-10 0:50am

I copy pasted your code. It's not working. :(

TejuKrishna 31-Dec-10 0:55am

My datahelper class contain this method please try it
public static void ExecuteCommand(string _command)
{
try
{
sqlcn.Open();
sqlcmd = new SqlCommand(_command, sqlcn);
_records = sqlcmd.ExecuteNonQuery();
}
catch (Exception)
{

throw;
}
finally
{
sqlcn.Close();
}
}
you can set Sqlconnection sqlcn=new SqlConnection("Paste Here Your Connection String");

TejuKrishna 31-Dec-10 1:01am

USe This connection string for sqlexpress. as well modify to map your datasource location
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"

sharathu7 31-Dec-10 1:10am

sorry getting error...

Line 15: public partial class adminpage_addlanguage : System.Web.UI.Page
Line 16: {
Line 17: Sqlconnection sqlcn = new SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=ASPNETDB;Integrated Security=True";
Line 18:
Line 19: protected void Button3_Click(object sender, EventArgs e)

TejuKrishna 31-Dec-10 1:15am

Simply Select your express database and view it's property you can get the connection string from it's property just paste it in connection string.

sharathu7 31-Dec-10 2:34am

Still error...

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1009: Unrecognized escape sequence

Source Error:

Line 15: public partial class adminpage_addlanguage : System.Web.UI.Page
Line 16: {
Line 17: Sqlconnection sqlcn = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename="G:\Project - MusicStore\App_Data\ASPNETDB.MDF";Integrated Security=True;User Instance=True");
Line 18:
Line 19: protected void Button3_Click(object sender, EventArgs e)

TejuKrishna 31-Dec-10 2:37am

put @ sign before connectionsting out side the qoute.

sharathu7 31-Dec-10 3:36am

thnks

Sandesh M Patil · Accepted Answer · 2010-12-30T19:09:00

Solution 3

see below link
Using ASP.NET With SQL Server

Posted 30-Dec-10 19:09pm

Sandesh M Patil

Comments

sharathu7 31-Dec-10 1:18am

thank u mate

sharathu7 1-Jan-11 2:11am

A new problem now... Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'seven\sharath'. this is my code... SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ASPNETDB;Integrated Security=True;User Instance=True"); con.Open(); SqlCommand cmd = new SqlCommand("insert into albumdetails(id,albumname,albumlanguage,musicdirector,copyright,year,price,discount,rating) values ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "')",con); cmd.ExecuteNonQuery(); con.Close();