|
You can see this[^] to know how to use stored procedure with asp.net.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks for stored procedur i will go thrugh tht link but in below given code i want Checkbox value like if it is checked then in table it should store 1 else 0.How i do this .When i write ChkEnquiry.Text ,it gived label Enquiry not its value.
if (ChkEnquiry.Checked== true)
{
a = ChkEnquiry.Text;
}
if(ChkPayroll.Checked==true)
{
b = ChkStock.Text;
}
if(ChkStock.Checked==true)
{
c= ChkPayroll.Text ;
}
strcmd = "Insert into CreateAccount values('" + txtUname.Text + "','" + txtPass.Text + "','" + txtCPass.Text + "','" + txtEmail.Text + "','" + txtSQuest.Text + "','" + txtSAns.Text + "','" +a.ToString() +"','" +b.ToString()+"','" +c.ToString()+"')";
SqlCommand cmd =new SqlCommand(strcmd,conn);
cmd.ExecuteNonQuery();
this.Controls.Add(new LiteralControl(" alert('Data Saved');"));
ClearTextBoxes();
Thanks & Regards
CARE CAREER
|
|
|
|
|
Care Career wrote: if (ChkEnquiry.Checked== true)
{
a = ChkEnquiry.Text;
}
What you want to store here?
You can give here
a = "1";
if a is a string variable.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks Problem is soved
CARE CAREER
|
|
|
|
|
Hi.
not sure if this would work, as I am relatively new:
"CheckBox1.Checked ? 1 : 0;"
Place that in the fields where you want to insert the 0/1 flag.
Hope it helps.
Marquin
|
|
|
|
|
Hi
On save button click event i have written this code:-
but i want ChkEnquiry value not Text. wht to write for this.
plz tell
if (ChkEnquiry.Checked== true)
{
a = ChkEnquiry.Text;
}
if(ChkPayroll.Checked==true)
{
b = ChkStock.Text;
}
if(ChkStock.Checked==true)
{
c= ChkPayroll.Text ;
}
strcmd = "Insert into CreateAccount values('" + txtUname.Text + "','" + txtPass.Text + "','" + txtCPass.Text + "','" + txtEmail.Text + "','" + txtSQuest.Text + "','" + txtSAns.Text + "','" +a.ToString() +"','" +b.ToString()+"','" +c.ToString()+"')";
SqlCommand cmd =new SqlCommand(strcmd,conn);
cmd.ExecuteNonQuery();
this.Controls.Add(new LiteralControl(" alert('Data Saved');"));
ClearTextBoxes();
thanks
CARE CAREER
|
|
|
|
|
Do validation on the textboxes first, pass them as variables to an SP and do the rest.
|
|
|
|
|
You can conver the check box field into Boolean and insert it..
Like
Insert into CreateAccount values('" + txtUname.Text + "','" + txtPass.Text + "','" + txtCPass.Text + "','" + txtEmail.Text + "','" + txtSQuest.Text + "','" + txtSAns.Text + "', " + Boolean.Parse(ChkEnquiry.Checked) + "," + Boolean.Parse(ChkStock.Checked) + ",'" + ChkPayroll.Text + "' )";
Try this one..hope it will helps you
KHATRI
|
|
|
|
|
I wanna save to client browser not save on server.
Can U help me????
this is code save on server:
protected void Page_Load(object sender, EventArgs e)
{
Process MyProc = new Process();
try
{
//MyProc.StartInfo.WorkingDirectory = ;
MyProc.StartInfo.FileName = Server.MapPath(@"pgsql2shp.exe");
MyProc.StartInfo.UseShellExecute = false;
MyProc.StartInfo.RedirectStandardError = true;
MyProc.StartInfo.RedirectStandardInput = true;
MyProc.StartInfo.RedirectStandardOutput = true;
MyProc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
MyProc.StartInfo.Arguments = @" -f download\myabcshp -h 10.0.0.3 -u postgres -P 123456 vietnamairlines " + '"' + "select * from province WHERE id IN(1,2,3,4,67,34)" + '"';
MyProc.StartInfo.CreateNoWindow = true;
MyProc.StartInfo.Verb = "Save";
MyProc.Start();
MyProc.WaitForExit();
}
catch (System.Exception ex)
{
return;
}
finally
{
MyProc.Close();
}
}
|
|
|
|
|
nobody help me??????
|
|
|
|
|
I wanted to write some certification course in Dotnet. Can you tell about the details and fees structure?
|
|
|
|
|
Microsoft[^]
You can select based upon your interest.
Regards,
Satips.
|
|
|
|
|
hi
i am now working on an aspx.page which has a download option and this page is displayed through plumtree portal. when i click download button it takes some values from server and opens it in excel with the help of download dialogbox. when i click submit there is an "error on page". when i see the source code of that page, the corresponding line for that error is handle focus function.
function Handlefocus()
{
if(timeoutwarningwindow)
{
if(!timeoutwarningwindow.closed)
{timeoutwarningwindow.focus();}
else
{window.top.onfocus="";}
}
return false;
}
}
if(timeoutwarningwindow)
{
window.top.onfocus=Handlefocus;
timeoutwarningwindow.focus()
}
why is that error on page appears. does this handle focus event creates problem for the opening of download dialogbox? if so what could be the possible solution? kindly clarify me on this.
By
SmogBird
|
|
|
|
|
Hi Everybody:
Can I See in log of IIS that which user has accessed the site and when?
|
|
|
|
|
Have you heard about that Asp.Net Site Navigation.
Hope this[^]will help you to keep tracing all the details about the user accessed the site and when.
Regards,
Satips.
|
|
|
|
|
Thanx for reply!
But i have a situation in which i have to trace the user who have accessed the website!I have not set any option for it.
Does the IIS not automatically maitain this information?
Any other solution to get this information while i have not made configuration for this perpose?
|
|
|
|
|
I'm developing Chat application in Flash, I Have to get the user name from asp.net page and continue the chat in Flash.
Plz tell me how to get the values from Asp.net page to Flash
Thanks in Advance
|
|
|
|
|
ASP.NET is a server-based platform, which means the code you write executes on the web server instead of in the client's browser. This approach ensures that your code is kept secure from prying eyes, and it sidesteps most browser-compatibility issues. However, it also introduces some unavoidable limitations.
So Enhance your Asp.Net pages with Javascript for calling it in Flash.
Regards,
Satips.
|
|
|
|
|
I'm developed Chat Application in Flash, But the User's login page is in Asp.net, I want the user name should be displayed in flash page. How to get the user name from that page.
The Flash chat window is embedded in Aspx page and it is running successfully in a web browser.
But I want to know how to get the user name from asp.net page to flash chat application.
Thanks in Advance
|
|
|
|
|
Can you tell me how to include flash in a aspx page?
i googled it but never found a good solution!
Gautham
|
|
|
|
|
|
is there any sort of sample code i could refer to
Gautham
|
|
|
|
|
i think that the flash could read a URL , so send the user name
in the query string.
but be careful not to send sensitive data in the query sting.
then if you need more data that the user name write it to xml, the flash could read xml file.
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Hi Friends,
I have 2 webforms.I am passing Textbox1 value to next page like this in the button click event
Response.Redirect("Page2.aspx?id=" & TextBox1.Text)
In the second page I have one hiddenField,one Html textfield ,one button is there I want to assign Querystring value to
Hidden Field for comaring both the values.
I tried like this
dim a as string=Request.querystring("id")
HiddenId.value=a.tostring
HiddenId.value is giving error.So any body could please give solution for this.
Thanks
|
|
|
|
|
Again getting problem ?
Whats the error that you are getting ?
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
