|
ellllllllie wrote: Can i create a web application setup
Yes you can Create a Web SetUp Project .
Have a look[^]
cheers,
Abhijit
|
|
|
|
|
Hi Experts,
I have a web site in ASP.Net with Sql Server 2000 as DB. My problem is that the web application is not allowing concurrent logins to it. Once a user logs into the site starts some process, the database get locked and other user can not get access to the site. For the first user it works fine but other concurrent connections it gives me following error message:
"{"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: SQL Network Interface..."<br />
I don't know whats the reason for this. I think I am missing some settings in my server.
I have used following connection string
"Data Source=MyServer; Initial Catalog=MyDb; User ID=un; Password=123456; MultipleActiveResultSets=True; pooling=true"<br />
Can anyone help me out. Its very urgent.
__________________
Regards,
Paramhans Dubey.
|
|
|
|
|
Check you code . Are you using Conn.Dispose() any where of your application ?
cheers,
Abhijit
|
|
|
|
|
Hi Abhijit,
Thanx For your reply. answer is No. I have not used Conn.dispose() anywhere in my code.
|
|
|
|
|
I think This[^] link will may help you out .
cheers,
Abhijit
|
|
|
|
|
Have you looked to see if anything is locked in your database after the first user has logged in?
|
|
|
|
|
Are you able to connect to the DB server via Query analyzer or through remote desktop.
Think you dont have rights to connect to the server.
|
|
|
|
|
Yes i am able to connect to database using query analyzer.
|
|
|
|
|
Then the problem is in the transaction that you are using.
Where is the transaction being controlled ? is it in the business layer or at the SQL level ?
Have you closed all the transactions properly ?
Have a look at the activity monitor, filter by the database and check.
|
|
|
|
|
1, How fill CheckBox
2, CheckBox value get it from database
3, as per database value (true/false). checkbox wil checked or unchecked
4, checkbox are in grideview
|
|
|
|
|
mayankb_07 wrote: 1, How fill CheckBox
CheckBox1.Text="Your Text"
mayankb_07 wrote: 2, CheckBox value get it from database
3, as per database value (true/false). checkbox wil checked or unchecked
Read Value from database
if(CheckedTrue())
{
CheckBox1.Checked=True;
}
Note : CheckTrue() Will return true and false based on your database value. You need to implement that.
mayankb_07 wrote: 4, checkbox are in grideview
Use TemplateField in Gridview
Hope this will helps to resolves all of your query .
cheers,
Abhijit
|
|
|
|
|
How to send sms on particular date like on birthday etc in asp.net..
|
|
|
|
|
Can you bit detail about you requirement?
Cheers!!
Brij
|
|
|
|
|
|
Thanks for reply..i already use webservice for sending sms..but now i want to send sms on specified date time whether your application is running or not..sms should be sent..
|
|
|
|
|
Write a console application and schedule it using windows scheduler.
|
|
|
|
|
Thanks for reply..plz would you tell me in some detail..
|
|
|
|
|
meghamaharshi wrote: would you tell me in some detail..
I am not sure that I can explain more clearly. My point was
1 - Create a console application
2 - This console application should communicate with necessary webservice(or whatever it is) to send SMS.
3 - It should exit automatically once finished.
4 - Put this console application exe on your server and schedule it using windows scheduler.
Was that enough?
|
|
|
|
|
Hi ,
I have a problem regarding grid view.I want to clear gridview without postback is it possible.I am using Asp.Net2.0 and C#.net
Thanks.
|
|
|
|
|
ais07 wrote: I want to clear gridview without postback is it possible
What does it mean ? Clear gridview mean no DataSource of Gridview.
cheers,
Abhijit
|
|
|
|
|
Thanks For Reply,
Actually problem is that as I am showing detail in on click of view button but I want to clear the detail on selected change event of dropdown list box.But problem is that,that dropdown list box is in update panel.
|
|
|
|
|
ais07 wrote: that dropdown list box is in update panel.
There is two solution
1. Put the Gridview on the same updatepanel where the dropdownlist is ( if no designing issue)
2. Put Gridview to another Updatpanel. Change the UpdatePanel property UpdateMode="Conditional" . Now on selectedIndexChanged of dropdownlist , update the Updatepanel of gridview UpdatePanel2.Update()
[Assume Updatepanel2 is the updatepanel which hold the gridview ]
I think, Option 2 is best for you !!!
let me know if any other issue .
cheers,
Abhijit
|
|
|
|
|
Thanks For Reply Abhijit,
2nd solutions works.
Thanks.
|
|
|
|
|
Great !!! Go ahead !!
cheers,
Abhijit
|
|
|
|
|
i m using jquery datepicker with gridview (in Template field) but it shows only in first row of gridview in rest rows it is missing
how can i solve it
thankx in advance
|
|
|
|