|
Good morning
Write a method like the below to populate the form
// could be global
private string strErrorMsg = "Database error: " + exp.Message;
try
{
SqlConnection conn = new SqlConnection(put your connection string hear);
strSQL = "SELECT * FROM theNameOftheTable";
SqlCommand cmd = new SqlCommand(strSQL, conn);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
// a method to display the information, is this a grid or form with textboxes?
conn.Close();
cmd.Dispose();
conn.Dispose();
}
catch
{
//some message about the error
strErrorMsg;
}
|
|
|
|
|
How do you add/save a row using the INSERT sql command in a web form with textbox not a datagrid? Below is my code, what wroung and why does fall through to the "finally block?"
private void SaveRecord()
{
string strSQL;
if(btnSave.CommandArgument == "Add")
{
strSQL =
"INSERT INTO CoinCollection " +
" (ID, TypeOfCoin, YearOfCoin, StateOfCoin, DateReceive)" +
"VALUES " +
" (@ID, @TypeOfCoin, @YearOfCoin, @StateOfCoin, @DateReceive)";
}
else
{
// The user is updating an existing item
strSQL =
"UPDATE CoinCollection " +
" SET TypeOfCoin = @TypeOfCoin, " +
" YearOfCoin = @YearOfCoin, " +
" StateOfCoin = @StateOfCoin, " +
" DateReceive = @DateReceive " +
"WHERE ID = @ID";
}
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["connString"]);
SqlCommand cmSQL = new SqlCommand(strSQL, conn);
// Add all the requuired SQL Parmeters.
cmSQL.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = Convert.ToInt32(tbID.Text);
cmSQL.Parameters.Add(new SqlParameter("@TypeOfCoin", SqlDbType.VarChar, 50)).Value = tbToc.Text;
cmSQL.Parameters.Add(new SqlParameter("@YearOfCoin", SqlDbType.VarChar, 50)).Value = tbYoc.Text;
cmSQL.Parameters.Add(new SqlParameter("@StateOfCoin", SqlDbType.VarChar, 50)).Value = tbSoc.Text;
cmSQL.Parameters.Add(new SqlParameter("@DateReceive", SqlDbType.VarChar, 50)).Value = tbDr.Text;
try
{
conn.Open();
cmSQL.ExecuteNonQuery();
strMsg = "Coin successfully saved to the database.";
}
catch(Exception exp)
{
strErrorMsg = "Database error! Coins not saved to database. Error Message: " + exp.Message;
}
finally
{
conn.Close();
btnAdd.Enabled = true;
}
}
|
|
|
|
|
Hi there,
Can u post the error exception message?
<< >>
|
|
|
|
|
Good morning and thanks for looking at this for me. The answer to your question is "no" the program drops through the exceptions to the finally block and executes the code to enable the Add button.
Brent
|
|
|
|
|
I did'nt try.... 
|
|
|
|
|
hi,
i need to access different servers providing same web service interface. when i want to access them i need to create two different web references.
when i access each of them i create instance of the webservice link and invoke a method.
i need to parse the 'return' object that i get it when i invoke a web service. the problem is i need to parse it separately the returns from two different webservices because of classCast problem.
most probably i am doing something wrong. how do i update my code so that i have common parsing and invocation methods for both of these services with same web service interface.
regards,
rnv
|
|
|
|
|
Hi there,
We have a web application written in asp.net (1.1). Without going
into too much detail, we use a DLL to communicate with the database and
also a couple of webservices. When we deployed version 1, everything
deployed OK on our webserver. We deployed the application and 1 webservice
under default web site, the other webservice (3rd party supplied) is on
another server and services many other application in our organisation
sucessfully.
Recently we have tried to deploy version 2, but this time we have assigned
another IP address to the web server and tried to install the application
under a new website. Everything looked OK the application installed OK and
most of the functionallity works just fine but 1 or 2 of the webservice calls
fails with the error:
"Index was outside the bounds of the array"
I get this error on both webservices, on specific webmethods, but it DOES
work OK on default website....
Any help on this would be appreciated
Cammie
|
|
|
|
|
The error message is not at all specific for web services. The error is plainly as the message says; somewhere there is an array, and an attempt is made to access an item at an index that is outside the bounds of the array.
Does the error message come from the code calling the wbe service, or does the error message come from the code executed in the web service?
---
b { font-weight: normal; }
|
|
|
|
|
Hi there,
Thanks for your interest.
It looks like the web service returns no data and the calling code is falling over when populating a grid. As I have stated earlier, the code runs fine from 'default' website.
Cammie
|
|
|
|
|
This question is related to java program if any budy knows it please give me answer bcz i am new to the java technology sir. The problem is
i am using 3 methos
<br />
public void setDay(String s)<br />
{<br />
day = s;<br />
}<br />
<br />
public String getDay()<br />
{<br />
return day;<br />
}<br />
<br />
public void setMonth(String s)<br />
{<br />
month = s;<br />
}<br />
<br />
public String getMonth()<br />
{<br />
return month;<br />
}<br />
<br />
public void setYear(String s)<br />
{<br />
year = s;<br />
}<br />
<br />
public String getYear()<br />
{<br />
return year;<br />
}<br />
<br />
public Date getCust_dob()<br />
{<br />
cust_dob = valueOf(year + "-" + month + "-" + day);<br />
return cust_dob;<br />
}<br />
when i was trying to compile the program i am getting an error:
cannot find symbol valueOf(String)
if any budy knows about this kindly response me..
|
|
|
|
|
You have to specify for what class you want to call the ValueOf method.
cust_dob = Date.valueOf(year + "-" + month + "-" + day);
---
b { font-weight: normal; }
|
|
|
|
|
How to capture the Click event of radio button list in Datagrid?
|
|
|
|
|
I cannot find winhttp.h and winhttp5.lib files on my computer.  Where I can get it?
At least, can anybody be so kind to send these me via e-mail: dubovoy@host.kr.ua
Thanks a lot.
|
|
|
|
|
When a user clicks on a download button, it should popup an window asking for the type of file(it may contain dropdown list with list of values populated from a database). Based on the selection, the corresponding file format to be downloaded. How to incorporate the same in ASP.Net and how to invoke a message box like a normal application and also how to capture the command button clicked on the dialog box?
Thanks in advance
|
|
|
|
|
As the dialog should be displayed on the client side, you can't use ASP.NET to do it. The ASP.NET code is run on the server, using a dialog box would display it on the server, not on the client.
You have to use javascript to open a window with a page that let's the user do the selection.
---
b { font-weight: normal; }
|
|
|
|
|
|
The first page opens in about four seconds, the second in about 20 seconds.
I'm sitting in Sweden on a broadband connection (10 mbit/s).
---
b { font-weight: normal; }
|
|
|
|
|
thanks very much,
it seems slow.
|
|
|
|
|
is there any var to use mshtml.dll with server.createobject
karanba
|
|
|
|
|
hi,
i have developed a .net xml web service in C#. This web service will be used by another program developed by another company. This company expects my web service's WSDL file in a customized format of standard .net web service WSDL.
Such customizations of porttype tag name attribute, port tag name attribute and so on...
I nearly changed all required tag names and attributes of WSDL by .net attributes in code.
But I could not change input/output tags message attributes, and i need to change these attribute values. I searched for that in google and msdn but found nothing. i need to change the port tags to this values:
<portType name="DispatchSMSImpl">
<operation name="dispatchSMS">
<input message="tns:dispatchSMS" />
<output message="tns:dispatchSMSResponse" />
</operation>
</portType>
<message name="dispatchSMS">
<part xmlns:partns="http://www.w3.org/2001/XMLSchema" type="partns:string" name="String_1" />
</message>
<message name="dispatchSMSResponse">
<part xmlns:partns="http://www.w3.org/2001/XMLSchema" type="partns:string" name="result" />
</message>
Are there any attributes that can magically change the input message and output message attributes?
Or with any other method?
thanks.
|
|
|
|
|
Hi every1,
Actually i am doing a parsing of web log files.....n there r 2 probs
1-web log fields are not predetermined especially in the case of w3c format... now how can i determine the order of the fields, that is placement of date/time, user ip etc.
will ask u the second one afterwards...
bye bye
|
|
|
|
|
The best place to find out about the w3c format is to go to THE SOURCE and read the working draft. That way, you will know the log file format, know how to determine the order of the fields, and can parse it efficiently.
"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty
-- modified at 17:13 Saturday 26th November, 2005
|
|
|
|
|
hello
i am working in asp2.0
i want to work with MS Access as my data provider for storing profile information and other tasks
could any body tell me how to configure MS Access for this
thnx
|
|
|
|
|
Hi there,
m_amin83 wrote: could any body tell me how to configure MS Access for this
What do u mean "configure" here??? MS Access is just as a backend DB...just simply install it and create DB and coding something to connect to DB...
<< >>
|
|
|
|
|
I'm new to the development of web sites and web based applications; have a lot of Unix/C++ development experience, but not much VS or .NET. Anyway, I'm wanting to develop a web site but confused about the differences and tradeoffs between three different Microsoft toolsets: Front Page 2003, Visual Web Developer 2005, and Microsoft's Web Matrix. I believe that VWD and Web Matrix are both front-ends for ASP.NET, but unsure of the differences between the two. As for Front Page 2003, not sure if it employs ASP.NET technology, and whether it affords greater flexibility than the other two options (am assuming it does). Would appreciate any thoughts that might help me to understand the differences between the three. Thx...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
