Unable to make connection to database?

Hy guys. I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.

I have database called PhoneDirectory.

It have only one table named Residents.

I have button wiht ID="Button1".

I want when i click this button to see all of my residents.

I want to see the result in DetailsView and to be able to edin, delete and add new resident.

First try with SqlDataSource so i wrote this:

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"

SelectCommand = "SELECT * FROM Resident "

UpdateCommand = "UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum," +

"HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum" +

"WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +

"HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"

InsertCommand = "INSERT INTO Resident FNAME, LNAME, MobileNum, HomeNum, OfficeNum, FaxNum" +

"VALUES ( '@FNAME', '@LNAME', '@MobileNum', '@HomeNum', '@OfficeNum', '@FaxNum')" +

"WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +

"HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"

DeleteCommand = "DELETE Resident WHERE FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum," +

"HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum" +

"WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +

"HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum" >

</asp:SqlDataSource>

For the DetailsView - >

<asp:DetailsView ID="Resident Details" runat="server" Height="50px" Width="125px" DataSourceID="Resident Details">

</asp:DetailsView>

And now i don't know how to bind all these 3 things. Please help.

P.S. I guess i miss something in SqlDataSource like Parameters but i'm not sure what to add.

I use Beginning ASP.NET 3.5 in C# 2008 From Novice to Professional, Second Edition for this.

Re: Unable to make connection to database?

Veschich
And now i don't know how to bind all these 3 things.

Start looking at: http://www.asp.net/web-forms/data

Re: Unable to make connection to database?

Well there's a lot of info but where to begin? I mean a wrote a code and i think it has to be filled with something not to write it again right?

Re: Unable to make connection to database?

Veschich
Well there's a lot of info but where to begin?

Since you are using SqlDataSource then you can start by following this example: http://www.asp.net/data-access/tutorials/inserting-updating-and-deleting-data-with-the-sqldatasource-cs

Re: Unable to make connection to database?

Ok. I'v read again a lot of information, repair my code but still need help. This is my code:

<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>" </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> SelectCommand = "SELECT * FROM Resident "</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> UpdateCommand = "UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum," +</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum" + </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> InsertCommand = "INSERT INTO Resident FNAME, LNAME, MobileNum, HomeNum, OfficeNum, FaxNum" + </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "VALUES ( '@FNAME', '@LNAME', '@MobileNum', '@HomeNum', '@OfficeNum', '@FaxNum')" + </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> DeleteCommand = "DELETE Resident WHERE FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum," +</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum" + </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum" ></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <UpdateParameters></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="FNAME" Type="String" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="LNAME" Type="String" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="MobileNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="HomeNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="OfficeNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="FaxNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </UpdateParameters></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <InsertParameters></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="FNAME" Type="String" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="LNAME" Type="String" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="MobileNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="HomeNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="OfficeNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="FaxNum" Type="Int" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </InsertParameters></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <DeleteParameters></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:Parameter Name="FNAME" Type="int" /> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </DeleteParameters></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </asp:SqlDataSource></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <br /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:GridView ID="GridView1" runat="server" DataSourceID="Resident Details" AutoGenerateColumns="True" PageSize="10" AllowPaging="True" style="font-family: Verdana"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <Columns></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:BoundField DataField="FNAME" HeaderText="First Name" SortExpression="FNAME" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:BoundField DataField="LNAME" HeaderText="Last Name" SortExpression="LNAME" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:BoundField DataField="MobileNum" HeaderText="Mobile Number" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:BoundField DataField="HomeNum" HeaderText="Home Number" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:BoundField DataField="OfficeNum" HeaderText="Office Number" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:BoundField DataField="FaxNum" HeaderText="Fax Number" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:CommandField ShowEditButton="True" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:CommandField ShowDeleteButton="True" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <asp:CommandField ShowInsertButton="True" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </Columns></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </asp:GridView></div>

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"

SelectCommand = "SELECT * FROM Resident "

UpdateCommand = "UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum," +

"HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum" +

"WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +

"HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"

InsertCommand = "INSERT INTO Resident FNAME, LNAME, MobileNum, HomeNum, OfficeNum, FaxNum" +

"VALUES ( '@FNAME', '@LNAME', '@MobileNum', '@HomeNum', '@OfficeNum', '@FaxNum')" +

"WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +

"HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"

DeleteCommand = "DELETE Resident WHERE FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum," +

"HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum" +

"WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum" +

"HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum" >

<UpdateParameters>

<asp:Parameter Name="FNAME" Type="String" />

<asp:Parameter Name="LNAME" Type="String" />

<asp:Parameter Name="MobileNum" Type="Int" />

<asp:Parameter Name="HomeNum" Type="Int" />

<asp:Parameter Name="OfficeNum" Type="Int" />

<asp:Parameter Name="FaxNum" Type="Int" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="FNAME" Type="String" />

<asp:Parameter Name="LNAME" Type="String" />

<asp:Parameter Name="MobileNum" Type="Int" />

<asp:Parameter Name="HomeNum" Type="Int" />

<asp:Parameter Name="OfficeNum" Type="Int" />

<asp:Parameter Name="FaxNum" Type="Int" />

</InsertParameters>

<DeleteParameters>

<asp:Parameter Name="FNAME" Type="int" />

</DeleteParameters>

</asp:SqlDataSource>

<br />

<asp:GridView ID="GridView1" runat="server" DataSourceID="Resident Details" AutoGenerateColumns="True" PageSize="10" AllowPaging="True" style="font-family: Verdana">

<Columns>

<asp:BoundField DataField="FNAME" HeaderText="First Name" SortExpression="FNAME" />

<asp:BoundField DataField="LNAME" HeaderText="Last Name" SortExpression="LNAME" />

<asp:BoundField DataField="MobileNum" HeaderText="Mobile Number" />

<asp:BoundField DataField="HomeNum" HeaderText="Home Number" />

<asp:BoundField DataField="OfficeNum" HeaderText="Office Number" />

<asp:BoundField DataField="FaxNum" HeaderText="Fax Number" />

<asp:CommandField ShowEditButton="True" />

<asp:CommandField ShowDeleteButton="True" />

<asp:CommandField ShowInsertButton="True" />

</Columns>

</asp:GridView>

And here's the errors it gain:

Build (web): The server tag is not well formed. - this line --->>> <asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"

and:

Literal expressions like '<%$ ConnectionStrings:ThisIsTheConnection%>' are not allowed. Use <asp:Literal runat="server" Text="<%$ ConnectionStrings:ThisIsTheConnection%>" /> instead.

at this line --->>> <asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"

Any guesses???

Re: Unable to make connection to database?

You may not concatenate the strings in UpdateCommand, InsertCommand and DeleteCommand properties in this way. The right syntax is

UpdateCommand = "UPDATE Resident SET ...,
MobileNum=@MobileNum,
HomeNum=@HomeNum,
...
FaxNum=@original_FaxNum"

(no ..."+"..."+"...)

Hope this helps.

Re: Unable to make connection to database?

Why are you using "+" to concatenate the rows.

Do not use "+".

Do it like this:

UpdateCommand = "UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum,

HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum

WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum

HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"

"UpdateCommand" tag color will become red and the rest will become blue color.

Hope this will help you.

Re: Unable to make connection to database?

as far as i understand this is for better viewing because i think:

<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">"UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum," +</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> "HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum" + </div>

"UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, OfficeNum=@OfficeNum" +

"FaxNum=@FaxNum"

in two lines is equal as:

"UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, " OfficeNum=@OfficeNum, FaxNum=@FaxNum"

in only one.

I think the problem is somewhere else. Plus that for now i don't connect Button1 with the SqlDataSource so may be here's the problem?

Re: Unable to make connection to database?

Veschich

I think the problem is somewhere else.

It's not true. The syntax with ..."+".."+"... is wrong. It's a Visual Basic thing which is not accepted in the tag writing. Please remove end quotes and plus signs at the end of each line and quotes at the beginning of each line and see what happens.

Re: Unable to make connection to database?

You are right. I fix this but now this happen:

Build (web): Type 'System.Web.UI.WebControls.SqlDataSource' does not have a public property named 'ConnectionStrings'

At this line --->>> <asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"

<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"

SelectCommand = "SELECT * FROM Resident "

UpdateCommand = "UPDATE Resident SET FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum, HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"

InsertCommand = "INSERT INTO Resident FNAME, LNAME, MobileNum, HomeNum, OfficeNum, FaxNum VALUES ( '@FNAME', '@LNAME', '@MobileNum', '@HomeNum', '@OfficeNum', '@FaxNum') WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum"

DeleteCommand = "DELETE Resident WHERE FNAME=@FNAME, LNAME=@LNAME, MobileNum=@MobileNum, HomeNum=@HomeNum, OfficeNum=@OfficeNum, FaxNum=@FaxNum WHERE FNAME=@original_FNAME AND LNAME=@original_LNAME AND MobileNum=@original_MobileNum HomeNum=@original_HomeNum AND OfficeNum=@original_OfficeNum AND FaxNum=@original_FaxNum" >

<asp:Parameter Name="FNAME" Type="String" />

<asp:Parameter Name="LNAME" Type="String" />

<asp:Parameter Name="MobileNum" Type="Int" />

<asp:Parameter Name="HomeNum" Type="Int" />

<asp:Parameter Name="OfficeNum" Type="Int" />

<asp:Parameter Name="FaxNum" Type="Int" />

</UpdateParameters>

<asp:Parameter Name="FNAME" Type="String" />

<asp:Parameter Name="LNAME" Type="String" />

<asp:Parameter Name="MobileNum" Type="Int" />

<asp:Parameter Name="HomeNum" Type="Int" />

<asp:Parameter Name="OfficeNum" Type="Int" />

<asp:Parameter Name="FaxNum" Type="Int" />

</InsertParameters>

<asp:Parameter Name="FNAME" Type="int" />

</DeleteParameters>

</asp:SqlDataSource>

<br />

And i have this in web.config:

<add name="ThisIsMyConnection"

connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"

providerName="System.Data.SqlClient" />

</connectionStrings>

????

Re: Unable to make connection to database?

Great, at least one problem less.

I guess it's a typo, the property must be named as ConnectionString (no -s at the end).

Re: Unable to make connection to database?

Well. Yeah "s" was the problem and Int ->Int32. Now i want to know how to bind Button1 with SqlDataSource. When i click the button to open the GridView(and before that to be hidden of course) and to execute my written query?

Re: Unable to make connection to database?

<asp:Button OnClick="Button_Click" ...

then put at the top of the page

<%@ Page Language="vb" %>

...

Private Sub Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
GridViewID_HERE.Visible = True
End Sub

</script>

Re: Unable to make connection to database?

smirnov

<asp:Button OnClick="Button_Click" ...

then put at the top of the page

<%@ Page Language="vb" %>

...

<script language="VB" runat="server">

Private Sub Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
GridViewID_HERE.Visible = True
End Sub

</script>

I'm writing in C#?

Is this code going to work?

Re: Unable to make connection to database?

<script runat="server">


protected void Button_Click(object sender, EventArgs e)
{
GridViewID_HERE.Visible = true;
}


</script>

Re: Unable to make connection to database?

Another problem come up:

An attempt to attach an auto-named database for file D:\WebSites\PhoneDirectory\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Here i want to say that my database is not in the same directory as the web site:

1. Is it have to be?

2. Why try to open aspnetdb.mdf ?

Re: Unable to make connection to database?

The ASPNETDB.MDF is the default database for using the ASP.NET Application Services, which includes profiles, roles, membership and more. It gets automatically generated whenever you use one of the above services. I believe you want to use a database which is already exist somewhere on the server. In this case your connection string which you set for the SqlDataSource control must include server name, login and password, like

"Data Source=SERVER;Persist Security Info=True;User ID=myId;Password=myPW"

Re: Unable to make connection to database?

Where to add it:

here ->

<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <connectionStrings></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="ThisIsMyConnection"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> providerName="System.Data.SqlClient" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </connectionStrings></div> <div></div>

<add name="ThisIsMyConnection"

connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"

providerName="System.Data.SqlClient" />

</connectionStrings>

<div>or -> in SqlData Control</div>

Re: Unable to make connection to database?

It must be in the web.config file.

Re: Unable to make connection to database?

here's what in my webconfig file:

connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI; Persist Security Info=True;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true; User ID=___\veschich;"

but i'm not sure about some stuff.

My server name = "____\VESOMANIA"

My user name = "____\veschich"

i don't have a password.

Is this the way webconfig has to be?