|
Attempt to connect to the database using ADO.NET before allowing the page to load, ie
System.Data.OleDb conncetion = new System.Data.OleDb(connectionString);
connection.Open();
|
|
|
|
|
How could I connect to ms-sqlserver by using ASP Language?
|
|
|
|
|
First of all, this is a very fundamental question. If you don't know this, you are not ready for programming.
To start, read some books/articles on the internet. Then try out a few samples. Better, try developing a simple application.
Issues will keep coming. Learn this[^]! 
..Go Green..
|
|
|
|
|
|
|
DECLARE @spot SMALLINT
DECLARE @str VARCHAR(8000)
DECLARE @strQuery nVARCHAR(1000)
DECLARE @sql VARCHAR(8000)
DECLARE @cslist VARCHAR(8000)
declare @Count int
set @Count=0
set @cslist='CallLog1230,CallLog2230'
MainLoop:
WHILE @cslist <> ''
BEGIN
SET @spot = CHARINDEX(',', @cslist)
print @spot
IF @spot>0
BEGIN
SET @str = CAST(LEFT(@cslist, @spot-1) AS varchar)
SET @cslist = RIGHT(@cslist, LEN(@cslist)-@spot)
print @cslist
goto InComing
goto OutGoing
END
ELSE
BEGIN
SET @str = CAST(@cslist AS varchar)
SET @cslist = ''
print @str
if(@Count=0)
Begin
set @Count=1
goto InComing
goto OutGoing
End
Else
goto EndLoop
END
End
InComing:
Begin
print 'IN'
print @str
End
OutGoing:
Begin
print 'OUT'
print @str
goto MainLoop
End
EndLoop:
return
I am not return from the While loop Please help me to find where i am wrong
|
|
|
|
|
Remove "goto MainLoop" from bottom of "OutGoing:"
Hardik Panchal
|
|
|
|
|
In my asp .net web application project,I used two ajax calendar extenders for fromdate and todate and two text boxes to display the date.I have four radiobuttons.Before,After,between,equals.I have to disable the calendar extendar in page load and when the between radio button is checked,then only that two date calendarextendar will have to be enabled.
please help me to write java script to disable calendar extender 
Thank you
|
|
|
|
|
|
Add following code onclick handler of your radio button
document.getElementById("<% =formDate.ClientID %>").disabled = true;
|
|
|
|
|
Hi
My modalpopup panel displays behind the background class of the modal extender(and it is also not positioning to center).
And Backgound also not covering entire screen.
Z-index is setting properly. Works in FF.
Any suggestions would really appreciate.
|
|
|
|
|
same problem here.
it works fine in chrome also
but IE is not displaying properly
|
|
|
|
|
hi all,
can anyone tell me how to integrate stock market chart in asp.net application,how can i get api for that??
thanx in advance.........
|
|
|
|
|
Find your answer here[^].
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
in that one article is deleted ....can u give me information abt api...
i want to display india,UK,USA country's stock information..
|
|
|
|
|
Hi Experts,
I am trying to display webcam video/Preview Image in Web browser. But I am not successes I tried following Methods.
1. Search webcam component
2. Used API calls and some related DLL file also.
Thanks in Advance.
|
|
|
|
|
|
Hi,
I have a datatable with tableadapter, and two parameterized queries.
The queries are quite straightforward, the parameter is the product EAN code, or the product number, and it returns a single row with product information (description, available stock, etc).
They both work perfectly, except when I run them for a certain product.
So I copy the query to sql server management studio, and they run fine, also for the offending products.
Through some googling I found that it is a common problem occuring to many, having (alternating) to do with EnforceConstraints, or field lengths, or data type mismatch, or AllowDBNull, with one common denominator: the query does not run at all...
But my query does run, just not for a couple of products. So I compare the queried data of a "good" product with that of a "bad" one, and lo an behold, the data is the same. No missing data, no differences in length, or data type, or anything.
Anyone who can shed some light on this, will be my hero.  ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Cheers,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
When the data has been verified manually, repeatedly, this error is usually the result of a constraint being accidentally assigned to the wrong column. Ie, instead of Customer.id = order.CustomerId you may have Customer.Id = order.ProductId. The constraints work in most cases for populated databases, however, fail at seemingly odd interval with no other explanation.
|
|
|
|
|
Thanks Ray, at the very least I am glad to hear I am not just crazy.
Ennis Ray Lynch, Jr. wrote: fail at seemingly odd intervals
In my case the query consistently fails when I run it with one product number and succeeds when I run it with another. When I run the page (query) in quick succession (good one, bad one, good one, bad one, etc) it consistently succeeds and fails (perhaps the title of this post wasn't chosen too well...) Is this behavior what you meant, or would it occur completely at random?
If you have had to deal with this problem as well, can you please suggest a work around or something ?
Cheers,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
You would have to post the schema's and the queries for the tables involved for someone to rule out database code. You mention that you are using a Table Adapter, are you using generated code or strongly typed DataTables? If so your code may not reflect your current database. For a quick test, in your ASPX code that is failing, randomly, replace your data access with straight data readers and no DataSet related objects and see if the error goes away. You have to slowly prove each piece of the code before you can identify which piece is wrong.
As for random, I seriously doubt the error is random, they never are. It is just the underlying cause has not yet been identified.
|
|
|
|
|
Unfortunately the table adapter is generated, so its a bit tricky to control, but I am going to take your advice and test my code until I find the offending bit.
I am also leaning towards your suggestion that the schema does not reflect the database, so I will first recreate the whole table adapter from scratch, to have it match up again. Who knows, that may already do the trick.
Thanks Ray, I appreciate your help.
My advice is free, and you may get what you paid for.
|
|
|
|
|
hi,
currently i m using asp.net 2.0 with c#.
here i always redirect to an page while error occurs(in catch block). but i need to know what exactly the user enter the data(to check the error).
so if error occurs, then i like to take a screen shot of the page and store inside some folder(say, errorFolder).
how to accomplish. plz help me - KARAN
|
|
|
|
|
First of, I don't know if this is possible, but think about this, user enters some thing into the form then hits enter, off goes the page to be processed, then ooops, you trip, how in the world are you going to take the screen shot of the user display from the server? You need something on the client, don't you?
Since you indicated you are catching ( and possibly logging ) the exception that may give you a clue. If you need more info, you can log user inputs as well. Since you know your form get the user inputs and don't forget input validation.
|
|
|
|
|
You do not need to take print screen for the same.
You can store exception in session and then use
afterward to determine the cause of error.
Like,
catch(Exception e)
{
Session["Error"]=e;
Response.Redirect("Error.aspx");
}
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
