|
I have created a dsn for sql server database. Now how do I code to open my database table to retrieve and save records in my table? Reply fast.
|
|
|
|
|
SSN wrote: I have created a dsn for sql server database
Why your are creating DSN for SQL Server ?
SSN wrote: Now how do I code to open my database table to retrieve and save records in my table? Reply fast.
Serach Google . Just learn Basic of ADO.NET
|
|
|
|
|
please tell me how code asp.net with vb using DSN of sql server 2005
|
|
|
|
|
Google is not working there ?? 
|
|
|
|
|
please tell me the sample code of connecting sql server database to my asp.net web application using vb
please.....  reply fast...........
|
|
|
|
|
SSN wrote: tell me the sample code of connecting sql server database to my asp.net web application
While asking this type of Question , please Search google First. this is very simple and basic Question.
Any way Try This link
Ado.net + VB.NET Code[^]
SSN wrote: reply fast...........
You are not paying us. so dont post like that .
Good luck
|
|
|
|
|
|
Hi..
I am having a function getcities()in codebehind. I am writing javascript in aspx page and calling this function from javascript like this...
<% getcities(); %>
This wrks fine. But now i want to pass parameters in this function. So if i give
<% getcities(cityname, statename); %>
den it gives error - cityname & statename does not exist in current context. Here i have 2 var cityname & statename. can anyone tell me wat is the problem in this.
Thnku in advance...
|
|
|
|
|
When did you call that function ? in any event means some button click or what ?
|
|
|
|
|
hi ,
i ve 2 level menu tabs in asp.net page. in that i want to activate particular menu and sub menu on page load........
Ashok
|
|
|
|
|
Dear friendz,
I am binding morethan 100 records in to a dropdownlist control in my web project.
If I click the dropdownlist, It is showing more than 25 data with vertical scrollbar.
It is not feeling good to look.
I want to customize the displaying records.
It should display only 10 records with vertical scrollbar.
What I have to do? Pls help me
Thanks in advance
Balasubramanian K.
|
|
|
|
|
while adding records in Dropdown list, just add only 10 records that's it.
now what abot rest other ?
while retriving data add all in a dataset that you can use later rather than re-retreiving for DB or other data source.
Thanks
|
|
|
|
|
Thanks for your reply first.
But I dont get clear so far. I am coding like this. I am binding data by using dataset. This is my sample code
Dim dsCode As New DataSet
Dim strSql As String = String.Empty
strsql = "Select Code, Name From UsersList"
If sqlCon2.State = ConnectionState.Closed Then sqlCon2.Open()
Dim sdaCode As SqlDataAdapter
sdaCode = New SqlDataAdapter(strSql, sqlCon2)
sdaCode.Fill(dsCode)
ddlCode.DataSource = dsCode.Tables(0)
ddlCode.DataValueField = "Code"
ddlCode.DataTextField = "Name"
ddlCode.DataBind()
If sqlCon2.State = ConnectionState.Open Then sqlCon2.Close()
What I have to do?
Balasubramanian K.
|
|
|
|
|
where did you add the data in dropdown list ?
|
|
|
|
|
I fill the data in to my dataset(dsCode) and then add in to dropdownlist (ddlCode).
strsql = "Select Code, Name From UsersList"
ddlCode.DataValueField = "Code"
ddlCode.DataTextField = "Name"
ddlCode.DataBind()
By this way only, I can bind the data in to drop down list.
Balasubramanian K.
|
|
|
|
|
here you can restrict the number of records that will add in dropdown list.
but how you will show other records ?
|
|
|
|
|
Actually, My question is that.
My query is retriving more than 100 records. When click the drop down list, it should show top 10 records only with vertical scroll bar. By using the vertical scroll bar user has to move the 11th record, 12th record in such way. I have to code according to the above condition.
Balasubramanian K.
|
|
|
|
|
what is the use of this statement FormsAuthentication.SetAuthCookie(oUserID, False)
if i assign in login page what happen, how to check after login user verified or not which condition i need to check
Request.IsAuthenticated is always showing true,
when it will be true and when it will false,
for setting Request.IsAuthenticated =true what we need to do
This is haneef.............................................................
|
|
|
|
|
For the web based application such as ASP.NET, there has limited storage to
persist some status info between client and serverside, cookie is the most
common one, so generally sessionState , Forms based authentication's ticket
... are all stored in cookie by default. When cookie is not allowed, URL
string is the only alternative. There is no other place which can help
store info (specific to a certain client/browser) and can be accessed by
server .....
Also, as for Response.Cookies.Add(cookie), it always add the value into
the ASP.NET response's cookie collection (Forms Authentication or Session's
cookieless setting won't affect it). Also whether the Response.Cookies
collection's new values will be persisted at client depend on the
clientside browser's setting (browser support cookie or not , user allow
cookie or not....)
For general ASP.NET application user state management approaches, here is a
msdn article mentioned some common approaches:
#Nine Options for Managing Persistent User State in Your ASP.NET Application
However, if we need to some info persisted at clientside and to associated
some serverside resources/data, cookie or url string will be the only
approaches so far we have....
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
I have come across the "Operation Aborted" message before, and typically its caused by trying to alter the DOM before its completely loaded. This will happen for all current versions of IE (5.5, 6, 7). I have run into an occurence recently where i get the error in IE7, but not IE6. Has anybody had this weirdness before?
|
|
|
|
|
Hi -
I am trying to allow access to users to multiple projects with a common login page. In other words I would like to save the username, and the roles in session variables and use this session variable in other applications to authenticate roles and access. I seem to lose the session variables as I redirect to another project. Is there a way to save these session variables so that I canhave a single point of signon and share it across applications? Have read a lot about but am having problems getting it to work. Thanks in advance.
|
|
|
|
|
First of All This is a very good Question.
Well, You can Do it.
First of All There are Following mode of Session
1.inProc<br />
2.Off<br />
2.SQLServer<br />
4.StateServer<br />
5.Custome
Now Your Option Are
1. Use SQLServer Mode and Save Session on DB and Retreive from Other Appliaction.
2. If Both of your application runs on same AppDomain , then you can do it using inProc
3. User Some Other Methods to save data may be usinh Cookies
Let me know if its helps you.
|
|
|
|
|
|
Hi Abhijit-
Thanks for responding. I had looked at the link you suggested earlier and was unable to get it to work. Hope I could reach the author but don't know that I can. Any suggestions?
Thanks
|
|
|
|
|
Hello all,
I'm at a fairly large company that has a number of ASP.NET applications running on our servers. The apps all use various back end databases to store data and do various operations. Because of IT policies, devs are no longer allowed to access production servers. Passwords, including those for service accounts, are to be changed on a regular schedule. So, I'm thinking that it might be possible in ASP.NET to set the account that each app uses and then used trusted connections for SQL server to do what we need. That way, the network operations people can change passwords without us being involved.
This is all due to Sarbanes-Oxley and HIPAA (as well as just common sense corporate security). Has anybody had to deal with this? If so, what did you use to streamline configuration management of your various deployed applications? Are there any solutions that you would recommend avoiding?
Thanks,
Will
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
