i have looked all over the web to find how.. and cant find any.. does anyone actually have code to show how to do this?
please help someone> i have looked all over the web to find how..
really? I don't think you have, you know. for a start have you looked at the tutorials section of this site? or www.411asp.net? or www.4guysfromrolla.com? or my site? or in the .NET documentation?|||You may wish to look up System.Data.SqlClient
How many ways are there to connect to a database in ASP.NET? Could someone list them in a 1,2,3... manner.
For those who are going to ask why I want to know this and why I don't do one way, I'll explain after I get the answer.
http://msdn2.microsoft.com/en-us/library/ms178371.aspx
HTH,
Suprotim Agarwal
|||Thanks for reply.
I tried to creat a sqldatasource according to that page so I modified config file and added this:
<connectionStrings>
<add name="linksConnectionString" connectionString=" Server=local;Database=mahmood_links;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>
</connectionStrings>
and put this line on my aspx page:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:linksConnectionString %>"
SelectCommand="SELECT * FROM [link]"></asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="URL" HeaderText="URL" SortExpression="URL" />
<asp:BoundField DataField="TITLE" HeaderText="TITLE" SortExpression="TITLE" />
</Columns>
</asp:GridView>
But when I ran the file got lots of line of error, these are the first lines of error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
what could be the problem then?
|||Dear mahmood,
Do you have Sql Server 2005 sp2 installed on your computer. Kindly install that and see if that solves your problem.
After having done that, if the problem still persists, you can checkthis link.
HTH,
Suprotim Agarwal
|||Thanks for replies.
I found out that I needed this connectionstring for the server
Server=localhost;uid=myId;pwd=myPass;database=myDataBase
sqlHello,
There's actually no straightforwarffd answer as this will depend upon the transaction isolation level which will in turn determine how many transactions may read a row as well as what state the data read will be in (dirty, comitted etc). Only one transaction can ever modify a row.
Have a look at http://www.microsoft.com/technet/prodtechnol/sql/2005/cncrrncy.mspx and http://msdn2.microsoft.com/en-US/library/ms173763.aspx as well as BOL for information.
Cheers,
Rob
|||Iam using SQL server 2000 and don't have intended to update to sql server 2005, so i can't use RLV.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Thanks for your advise.Can you state the underlying purpose to what you are doing? It is not a natural thing to be interested in what row a user might be "connected" to. Now if you are talking about locking it for modification, that makes it a bit more clear, and you could use some form of lock to make that happen.
The thing is, SQL works in a very set oriented architecture, so you might touch a million rows when you think you end up only looking at one (it might require a scan of all values to find just one). SQL Server does nice things with locking, and there are techniques like optimistic locking that you can use to enhance concurrency, so if you could give a bit more information we might could suggest a better way.
|||Louis Davidson wrote:
Can you state the underlying purpose to what you are doing? It is not a natural thing to be interested in what row a user might be "connected" to. Now if you are talking about locking it for modification, that makes it a bit more clear, and you could use some form of lock to make that happen.
The thing is, SQL works in a very set oriented architecture, so you might touch a million rows when you think you end up only looking at one (it might require a scan of all values to find just one). SQL Server does nice things with locking, and there are techniques like optimistic locking that you can use to enhance concurrency, so if you could give a bit more information we might could suggest a better way.
Thanks for your post :).
My purpose at
begin is Sql server or My App will notify my client when data was
changed for any client who current connect to that row.
For example:
-user A connect and load row R1 into dataset(vb.net).
-user B also connect to that table and load row R2
- R1 and R2 has some column which has the same data
==>
when user change data on some column and finished it,a litle later,
because user B did not know data was changed and continue changed that
data...so if i sum on total column(for example)then may be the value
was double and that is what i don't expect.
Sorry about my poor English, but if you understand what i mean , please give me your advise
Thanks.
I get this error when i try to connect with my sql,
I created my SQL with MS SQL 2005 Workgroup,
the error is:
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
First obvious question:
What happened when you extended the schema with ASPNET_REGSQL.EXE?
Jeff
|||I agree with Jeff. We need more details to help you. Any update?