|
hi guys
in my application i am using datalist in which data is binding properly but i want to bind a dropdownlist from another data source
the same thing i am using in grid view that is working properly
but not in data list
grid view coding
<asp:templatefield itemstyle-horizontalalign="Left" headertext="PieceLength mtr" xmlns:asp="#unknown">
<itemtemplate>
<asp:dropdownlist id="DropDownList2" runat="server" datasource="<%# name() %>" width="100">
DataTextField="des_emb_peice_lenght">
<headerstyle wrap="False">
code behind page
public DataSet name()
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("cl_london.mdb");
OleDbConnection MyConn = new OleDbConnection(connectionString);
string type = null;
string id_emb = null;
type = Request.QueryString["type"];
id_emb = Request.QueryString["id_emb"];
if (type == null)
{
OleDbDataAdapter cmd1 = new OleDbDataAdapter("select des_emb_peice_lenght from design_emb_peice_details where Emb_des_code='" + Session["type1"] + "'", MyConn);
DataSet ds1 = new DataSet();
cmd1.Fill(ds1);
return ds1;
}
else
{
OleDbDataAdapter cmd1 = new OleDbDataAdapter("select des_emb_peice_lenght from design_emb_peice_details where Emb_des_code='" + type + "'", MyConn);
DataSet ds1 = new DataSet();
cmd1.Fill(ds1);
Session["id_emb_for_design"] = id_emb;
return ds1;
}
}
krishna veer singh
|
|
|
|
|
Hi all,
I installed Dot Net 2003 on a Windows XP service pack 2(64-Bit Machine).
When I try to create a new project then I got a error
(The Web server reported the following error when attempting to create or open the Web project
located at the following URL ; " http://localhost/WebApplication'.'Http/1.1 503 service Unavailable .)
How I reslove this problem . Can u Plz help Me.
Thanks a lot .
|
|
|
|
|
Probably IIS is missing or some permission problems...
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Did you installed web server on your XP and with fronte page extensions. if not open control panel--> Add Remove Programs --> On left page click Add Remove Windows Component and Select IIS , then double click and select all options --> Insert Windows XP professional CD and click Next.
Then Start Creating New Project.
|
|
|
|
|
hi!
I have a problem.
I want to store the "Father's Name" in our Sql Server2000 through the TextBox in Asp.Net application.
I am using this code:
protected void Button1_Click(object sender, EventArgs e)
{
string s="insert into vehicletype VALUES('"+TextBox1.Text+"')";
SqlDataAdapter da = new SqlDataAdapter(s,conn);
DataSet ds= new DataSet();
da.Fill(ds, "type");
}
Following error is displayed:
Incorret syntax near s;
unclosed quotation mark begore the character string ')'.
Please solve my problem as soon as possible.
thanks
|
|
|
|
|
Replace single quote with double single quote.
string s="insert into vehicletype VALUES('"+TextBox1.Text.Replace("'","''")+"')";
I suggest you to read about SQL Injections[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
hi! blue_boy
I am very thankful to you. Your Answer is absolutely solved my problem.
And I welcome your suggestion.
bye.
|
|
|
|
|
No problem,you are welcome.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hai All,
Can anyone tell me the encryption algorithm which will return only numbers? I need to encrypt salary.In table salary feild is integer.So i dont want to change the data type of that feild. So i request to give me an algorithm which return integer.
Thanks in advance.
With regards Lijo
|
|
|
|
|
If you're storing it as encrypted then the field doesn't have be an int datatype. Are you decrypting it on the fly? How many records? Consider whether you should be encrypting the salary or the earners identity.
But fortunately we have the nanny-state politicians who can step in to protect us poor stupid consumers, most of whom would not know a JVM from a frozen chicken. Bruce Pierson
Because programming is an art, not a science. Marc Clifton
I gave up when I couldn't spell "egg". Justine Allen
|
|
|
|
|
You could use a block mode cipher with a block size the same size as your integer however, without multiple blocks there can't be chaining so it reverts to a trivial to break encryption.
Since salary data is confidential but not mission critical an XOR approach is a good one. You can also use a One Time Pad method.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
Most of this sig is for Google, not ego.
|
|
|
|
|
Dear All.
I am working on ASP.net 2.0 and using Master Page in which I used one user control and using a text box and button control for searching on the top.
The logo.ascx files which used in Master page is as follows:
<table width="100%" border="1">
<tr><td>
<asp:Image ID="logoimage" runat="server" ImageUrl="~/images/samnlogo3.jpg" AlternateText="SAMN Logo" BorderWidth="0" />
<!--<img src="images/samnlogo3.jpg" alt="SAMN logo"/>--></td>
<td valign="baseline">
<div id="searchdiv" name="SearchDiv">
<asp:textbox id="SomeText" runat="server"></asp:textbox>
<asp:button id="Submit" runat="server" text="Submit Form"></asp:button>
Now I want to take the text in the text box to another aspx page please tell me a better suggestion. <%@ previous page> does not works in User Controls. Also I am confused with <form > tag how to use it in the Master there is a <form> tag which is mandatory.
Then I want to fetch the data of textbox to use as search criteria in my SQL Query.
Please help me I have tries all possible ways I can do. But I did not got any proper solution.
I need it urgently.
Thanks in Advance.
|
|
|
|
|
You could use querystring or Sessions to do that I think.
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
You could create a property on your master page to return the text of the text box and then you can reference this using MyMaster. (or something like that - can't remember off the top of my head).
|
|
|
|
|
Please Reply with proper example because I have these things already, creating property on master page, creating simple form without runat tag and previous page property and postback url things but I couldn't make it working so I need an exact working model.
Thanks
|
|
|
|
|
Hi all,
I have one problem , i have one website, after login my site it redirect to gmail home page , for this i need to authenticate my users to google , how to do?
if anybody knows plz give some idea?
Thanks & Regards
Sams
sams
|
|
|
|
|
You cant do that I dont think.
You cant control Google's login page. The user will just have to log into their own Google account.
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
you need to use the web service of Google but Google not providing any web service to login from other website.....
You Contact Customer Care of Google.
Regards,
Shaik Haneef
|
|
|
|
|
Hai all,
i have a wep page suppose webform1.aspx.
Here i have written some code within try catch block.
i have a messagebox(javascript) and i want to show ,if any error occurs in my page
try
catch ex as exception
msgbox(ex.message)
exit sub
end try
but my msgbox is not showing my error,instead it is displaying nothing.
but if i do with response.write in catch block,it is displaying the error.
If i want to show only in messagebox,
how can i display,
if any body have idea,plz let me know.
thanks in advance
kissy
|
|
|
|
|
msgbox work only in Local Not in Server
use RegisterClint Script Block insted of msgbox
Example
catch ex as exception
ClientScript.RegisterClientScriptBlock(me.GetType(),"key1","alert('" + ex.message + "')"
exit sub
end try
|
|
|
|
|
thanks for your response.
clientscript is giving some error,means am i need to import some namespace like that.
kissy
|
|
|
|
|
no need of import anything, i think Quotes may be mismatch please check it, then automatically solved your problem
Cheers...
|
|
|
|
|
try this i think this one work definitely
ClientScript.RegisterClientScriptBlock(Me.GetType(), "key1", "" & ex.message & "")
|
|
|
|
|
Hi,
I am getting request timeout error whenever I try to load my aspx page having the following code.
Note: I am getting this error only when I set debug="false" in web.config file. The size of the XML Doc which I am rendering to the control(XMLResult) is 10MB.
strxmlString = sbrwriter.ToString().Replace("xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"","");
strxmlString = strxmlString.Replace("xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"","");
strxmlString = strxmlString.Replace("<?xml version=\"1.0\" encoding=\"utf-16\"?>","").Trim();
XmlDocument Doc=new XmlDocument();
Doc.LoadXml(sbrwriter.ToString()) ;
System.Xml.Xsl.XslTransform trans = new
System.Xml.Xsl.XslTransform();
trans.Load(Server.MapPath(@"XSL\AutoIssuanceRules.xsl") );
XmlResult.Document=Doc;
XmlResult.Transform =trans;
Please suggest me a solution which does not require a change in the machine.config's session timeout settings.
Thanks in Advance.
|
|
|
|
|
10 MB mean too heavy to load so that only it showing time out....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
