|
* Please note i have also posted this in SQL forum as i dont know which is most appropriate. If a mod feel it is wrongly placed here i appologise, feel free to delete.
Problem:
Hi,
I need help with an sql query please.
I wish to insert a new record into a table, and instantly retreive the new records id. Is it possible to do this in one sql statement rather than an INSERT followed by the SELECT statement?
My INSERT looks like this:
string conn = System.Configuration.ConfigurationManager.ConnectionStrings["artisanConnectionString"].ConnectionString;
SqlConnection uniqueCon = new SqlConnection(conn);
//set SQL statement
SqlCommand cmd = new SqlCommand("INSERT INTO [tbl_Additional] (add_Item, add_Price) VALUES ('" + TextBox10.Text + "', '" + TextBox11.Text + "') ", uniqueCon);
cmd.Connection.Open();
try
{//insert/ add new record
//commit to database
cmd.ExecuteNonQuery();
//clear form add/edit
TextBox10.Text = null;
TextBox11.Text = null;
//confirm to user
ShowMessageBox("New unique Item Added!");
//update dataset
GridView2.DataBind();
}
catch
{
ShowMessageBox("Unable to add record!!! Please try again later.");
}
cmd.Connection.Close();
Any help would be greatly appreciated.
Thanks & Happy Easter!
|
|
|
|
|
Before you attempt resolving this problem on hand, seriously consider a re-design of your database query approach. Your application is vulnerable for SQL Injection attacks.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
how to get columns of table in order of their ordinal position instead of
alphabetical order of column name?
cn.GetSchema("Columns", restrictions)
output: column_name ordinal_position
...........ambit...............3
...........noise...............1
...........z...................2
required output: column_name ordinal_position
....................noise...............1
....................z...................2
....................ambit...............3
IS IT POSSIBLE?
|
|
|
|
|
hmm
try sort by ordinal_position in the query
unless I have mistaken your post
|
|
|
|
|
Hi,
I am using Ajaxcalendar control for dates as inputs value.
my requirement, i have validated the dates, that is i am using Rangevalidator control and compare validator for validation.
its working fine, if the date format is mm/dd/yyyy.
In my Application i have mulitple language selection,when i selected Germam,then the date format will be changed to dd.mm.yyyy, then i am unable to validate the textboxes.
please help me.
thanks & regards,
Mohan
|
|
|
|
|
its very urgent*****************************************
I'm sure it is to you but its annoying and will just get your ignored
only two letters away from being an asset
|
|
|
|
|
Well If i understand your post correctly you just need to find a validator which will compare all types of date formats correctly
I'm sure if you search the Internet you will find one which validates all the correct formats
hope this makes sense
|
|
|
|
|
|
no trying searching yourself and then provide what you have found so far then we can help you
|
|
|
|
|
I think it will solve your problem?
<asp:regularexpressionvalidator id="RegularExpressionValidator2" runat="server" controltovalidate="txttodate" errormessage="Enter Correct Date">
ValidationExpression="(0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d">
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
|
hi all
how to open multiple windows in asp.net.. pleas help
i need to generate the same quotation for several partners like a,b,c,d...
i am using this code in the save button ie.. how many records it inserts it should display the Quotaion or pop up the window...
ClientScript.RegisterStartupScript(Me.GetType(), "Message", "<script>window.open('frmquotation.aspx?quot=" & ViewState("Order") & "&pid=" & partner.Text & "&Type=" & ddlLeadtype.SelectedItem.Text & "&custid=" & ViewState("CustIdCOrp") & " &sourceLead=" & ddlLeadSource.SelectedItem.Text & "&optprint=" & rdPrint.SelectedItem.Text & "','a' + new Date().getTime(),'resizable=1,scrollbars=yes,width=800,height=768')</script>", True)
if there is any other way to display plz let me know..its very urrgent
|
|
|
|
|
Did you mean multiple windows or multiple steps in the opened child window?
The first statement and subsequent clarifications of your post contradict to a good chunk.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
window.open() is the only way to open multiple windows.
no any other way to open them.
you can use any extra tools for popup windows to display your recodrs which may be you can get from ajax toolkit.
|
|
|
|
|
I have a problem using ajaxToolkit:MaskedEditExtender..
if enter the value in time textbox but value should be greater than 12 hour format..is there anyway to solve the problem ..please help me.
<asp:textbox id="addrow15" width="80%" runat="server">
<ajaxtoolkit:maskededitextender id="MaskedEditExtender5" targetcontrolid="addrow15">
Mask="99:99" AcceptAMPM="true" MessageValidatorTip="true" MaskType="Time" ClearMaskOnLostFocus="true"
OnFocusCssClass="MaskedEditFocus" OnInvalidCssClass="MaskedEditError" InputDirection="RightToLeft"
runat="server" />
|
|
|
|
|
currently i m using ASP.NET with C# (.net 2005, 2.0 framework)
i have placed a calendar in my webform (calendar from "toolbox --> calendar"). when i press the ESC key, the calendar should get INVISIBLE... how to do this?
help me. - KARAN
|
|
|
|
|
You could use this and then find the correct key number for esc, i think this one is for when the enter button is pressed
if (window.event.keyCode == 13)
{
calendar.visible - false
}
hope this helps
|
|
|
|
|
i cant get the "window.event.keyCode" and where should i write this code?... where it is?
|
|
|
|
|
Hi John
Here is an example:
Add this script to the head of your page:
<script type="text/javascript">
function setCmdKey(event) {
if (event.keyCode == 27)
document.getElementById('mydiv').style.visibility = 'hidden';
}
</script> and add this as a body:
<body onkeydown="setCmdKey(event);" >
<div id="mydiv" style="padding:50px;background-color:#f00;">Make me disappear</div>
</body>
27 is the keycode for the escape key
|
|
|
|
|
THANKS A LOT MY DEAR!.. i m searching this for long time.. since i thought that we cant handle the SERVER SIDE process (.net calendar) in client side scripting (javascript).. i m not strong in JAVASCRIPT
|
|
|
|
|
s my friend. its help me a lot. but the thing is when i use more than one calendar, problem occuring. i.e...
function show_key ( the_key )
{
if ( ! the_key )
{
the_key = event.keyCode;
}
if(the_key == 27)
{
document.getElementById("Calendar1").style.visibility="hidden";
document.getElementById("Calendar2").style.visibility="hidden";
document.getElementById("Calendar3").style.visibility="hidden";
}
}
help me plz......... - KARAN
|
|
|
|
|
Since you haven't described what the problem is I will have to guess.
Are the 3 calendar controls on the page when you call the javascript?
Have they been written out to the browser?, you need to look at the page source to verify this.
My guess is that they are not all there so you will have to test for them in the javascript like this:
if(the_key == 27)
{
if(document.getElementById("Calendar1"))
document.getElementById("Calendar1").style.visibility="hidden";
if(document.getElementById("Calendar2"))
document.getElementById("Calendar2").style.visibility="hidden";
if(document.getElementById("Calendar3"))
document.getElementById("Calendar3").style.visibility="hidden";
}
|
|
|
|
|
thanks bright
|
|
|
|
|
if i click the button I want to validate time should not be greater than 12:59 using c# in asp.net. how ?
|
|
|
|
|
What a greatly worded question
you should have a look at the datetime property in c# and search on google that might be a start
|
|
|
|