|
First of all you should this is not appropriate place to post your query.. 
And please explain in detail...
Be an Eagle, Sky is Yours.
|
|
|
|
|
Hi suresh,
This is related to Asp.net web interface only..
In my post i clearly explained the way i am trying to do.
Anyways i am doing it for u again.
On my web interface i have option to browse two files and then a filter button.
whenever user clicks on filer button i need to filter the first file with second file so i am inserting these files into mysql tables and querying with NOT IN select statement.
I am getting connection timeout so pls suggest me the best way of filtering my files.
Thanks
|
|
|
|
|
333soori wrote: This is related to Asp.net web interface only..
Then why you have asked the same question on C# Forum also ?
333soori wrote: I am getting connection timeout so pls suggest me the best way of filtering my files.
Did you configured the Timeout Settings on connection string ? Or you can do one thing, Debug your application, and try to check where its taking the time.
Thanks !
|
|
|
|
|
Index your tables with appropriate key(s).
Avoid to use Not In. You can use something like this
select a.* from table1 a, table2 b
where a.column1<>b.column1
Configure your connection string's timeout parameter...
Be an Eagle, Sky is Yours.
|
|
|
|
|
i have a dropdownlist i bind it such like that it has different valuefield and different textfield. i want that i select textfield from dropdown and the value correspond that valuefield will insert in the database i write a code for it, it show datatype error.Failed to convert parameter value from string to a byte
<asp:DropDownList ID="ddlCType" runat="server"
DataSourceID="SqlDataSource1" DataTextField="CouponName"
DataValueField="CouponTypeID"
style="top: 309px; left: 389px; position: absolute; height: 11px; width: 97px; z-index: 1"
AutoPostBack="True" ontextchanged="DropDownList1_TextChanged">
</asp:DropDownList>
try
{
ErrorMessage.Text = "";
cnx.Open();
SqlCommand insertCmd = new SqlCommand("insert into CouponTransaction(CouponTypeID)values(@Id)", cnx);
insertCmd.Parameters.Add("@Id", SqlDbType.TinyInt);
insertCmd.Parameters["@Id"].Value = ddlCType.Text;insertCmd.ExecuteNonQuery();
ErrorMessage.Text = "Records inserted successfully";
cnx.Close();
}
|
|
|
|
|
haleemasher wrote: insertCmd.Parameters["@Id"].Value = ddlCType.Text;
You should use ddlCType.SelectedValue property for dropdownlist's selected item's value.
Be an Eagle, Sky is Yours.
|
|
|
|
|
Same error may i change this code also
insertCmd.Parameters.Add("@Id", SqlDbType.TinyInt);
|
|
|
|
|
Hi,
insertCmd.Parameters["@Id"].Value = ddlCType.Text;insertCmd.ExecuteNonQuery();
replace the above code with
insertCmd.Parameters["@Id"].Value = int.Parse(ddlCType.SelectedValue);insertCmd.ExecuteNonQuery();
|
|
|
|
|
haleemasher wrote: insertCmd.Parameters["@Id"].Value = ddlCType.Text
Use
insertCmd.Parameters["@Id"].Value = Convert.ToByte(ddlCType.SelectedValue);
Viral
|
|
|
|
|
it show another error Input sting was not in correct format
|
|
|
|
|
sorry my mistake
Use
insertCmd.Parameters["@Id"].Value = Convert.Int32(ddlCType.SelectedValue);
here you can use Int32 or Int16 depends on your requirement.
Hope this help
Viral
|
|
|
|
|
Hey! I need to display confirmation message in asp.net. I need to do something like this. Once user click Ok button some code execute and then return the confirmation message. According to the use response other code execute.Basically it is if/else statement. please help me how can i do it
Dushan Perera
|
|
|
|
|
|
- Add "OnClick" attribute on button and call javascript method.
- In this method write the Javascript confirmation message and on the basis on user response return true or false.
Note: Don't forget to return True or False
|
|
|
|
|
Basically i need common method to display the message. This class or page can use in the entire project
Dushan Perera
|
|
|
|
|
You can use Comman Floating DIV with Message and Button. This will make the things very easy. On any button click show the DIV and take the event from the DIV Button.
You can also look into JavaScript Confirm Box.
|
|
|
|
|
Dear friends,
i wrote a asp.net webservice using vs 2008 .net framework 3.5. this service runs over https.
it gets the parameters from the client and sends this to another application and then the answer from that application back to the client.
It works sometimes fine, bud sometimes im getting this exception:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
at System.Net.HttpWebRequest.GetResponse()
at WebService2.Service1.HttpSOAPRequest(String xmlfile, String proxy) in C:\Documents and Settings\BB\My Documents\Visual Studio 2008\Projects\WebService2\WebService2\Service1.asmx.cs:line 44
at WebService2.Service1.CardWithPerson(String persId, String projectId, String username, String pw) in C:\Documents and Settings\BB\My Documents\Visual Studio 2008\Projects\WebService2\WebService2\Service1.asmx.cs:line 82
--- End of inner exception stack trace ---
Here is some code of the webservice:
[WebMethod]
public String CardWithPerson(string persId, string projectId, string username, string pw)
{
xmlfile = "<?xml version=\"1.0\" encoding=\"utf-8\" ?> "
+ "<soap:Envelope xmlns:soap=\"http://www.w3.org/2001/12/soap-envelope\">"
+"<soap:Body>"
+"<PS_CardsWithPersonReq xmlns=\"http://tempuri.org\">"
+"<WebAuthenticate>"
+" <WebUser>"+username+"</WebUser>"
+" <WebPass>"+pw+"</WebPass>"
+" <WebIp>"+Context.Request.UserHostAddress+"</WebIp>"
+" <WebMd>0123456789ABCDEF0123</WebMd>"
+" </WebAuthenticate>"
+"<PersNr>"+persId+"</PersNr>"
+"<Lang>E</Lang>"
+"<ProjCode>"+projectId+"</ProjCode>"
+"</PS_CardsWithPersonReq>"
+"</soap:Body>"
+"</soap:Envelope>";
r = HttpSOAPRequest(xmlfile, null);
result = r.ReadToEnd();
return result;
}
StreamReader HttpSOAPRequest(String xmlfile, string proxy)
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlfile);
HttpWebRequest req = (HttpWebRequest)WebRequest.Create("http://211.144.244.244:7871");
if (proxy != null) req.Proxy = new WebProxy(proxy, true);
req.Headers.Add("SOAPAction", "\"\"");
req.ContentType = "text/xml;charset=\"utf-8\"";
req.Accept = "text/xml";
req.Method = "POST";
Stream stm = req.GetRequestStream();
doc.Save(stm);
stm.Close();
WebResponse resp = req.GetResponse();
stm = resp.GetResponseStream();
StreamReader strmReader = new StreamReader(stm);
return strmReader;
}
Here the code of the client side:
protected void Button1_Click(object sender, EventArgs e)
{
nl.test.testsoap.Service1 serv = new WebApplication1.nl.test.testsoap.Service1();
Response.Write(serv.CardWithPerson(textPersId.Text, txtProCode.Text, username, pw));
Response.End();
}
Can anyone help me with this issue?
Thanks
|
|
|
|
|
Just guessing, but the problem might occur when some of your variables (username, pwd, persID, projectId, ....) have invalid chars, like xml schema chars.
Seems your webservice is accessing other webservice, right? If you're using Visual Studio, you can just reference the other webservice (Right click on project -> Add Web Reference). VS will automatically create a new class encapsulating the webservice, so you just call for WebServiceClass.PS_CardsWithPersonReq method with the parameters. You might need WS Secutity to authenticate.
Regards,
Leonardo Muzzi
|
|
|
|
|
Hi,
Can you please highlight the line numbers indicated in the error message or can you paste the code with the line numbers.
Gayani
|
|
|
|
|
Hi Gayani Devapriya,
Thanks for your response.
This is the line:
WebResponse resp = req.GetResponse();
You can see it In the methode: StreamReader HttpSOAPRequest(String xmlfile, string proxy)
|
|
|
|
|
Hi,
The problem is solved by adding
req.KeepAlive = false;
ofter creating the request 
|
|
|
|
|
I used the following code to redirect from current page is this correct?
I don't want to write a javascript function for this one line,
instead of i wish to redirect using this method.can i do?
imgbtnUserIcon.Attributes.Add("onclick", "javascript:window.location.href('memberactiveprofile.aspx')");
|
|
|
|
|
Response.Redirect("aaa.aspx")
|
|
|
|
|
amarnath n.n wrote: Subject:Please reply me
This should not be the subject. It should be your query.
amarnath n.n wrote: I don't want to write a javascript function for this one line,
instead of i wish to redirect using this method.can i do?
Is it server side control ? if yes, then OnClick Event use Response.Redirect(); to navigate .
|
|
|
|
|
First, before posting again please read How to get an answer to your question at the top of this forum.
If you want to do it client-side then
mgbtnUserIcon.Attributes.Add("onclick", "javascript:window.location.href='memberactiveprofile.aspx'");
window.location.href is a property, not a method;
only two letters away from being an asset
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
