HI,
protected void btnUpdate_Click (object sender, EventArgs e)
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection() ;
MyConnection.Co nnectionString =
ConfigurationMa nager.Connectio nStrings["ConnectionStri ng"].ConnectionStri ng;
MyConnection.Op en();
MyCommand...
User Profile
Collapse
-
karenkksh started a topic How to solve Procedure or function 'StaffApplyLeave' expects parameter '@h_id', whichin .NETHow to solve Procedure or function 'StaffApplyLeave' expects parameter '@h_id', which
-
how to generate no of days in txtDay by substracting datetime that entered in textbox (txtTill) and datetime that entered in textbox(txtFrom )?... -
How to generate number of day in txtDay by subtraction two datetime?
public partial class Staff_nHolidayL eave : System.Web.UI.P age
{
protected void Page_Load(objec t sender, EventArgs e)
{
}
protected void btnUpdate_Click (object sender, EventArgs e)
{
SqlConnection MyConnection;
SqlCommand MyCommand;
MyConnection = new SqlConnection() ;
MyConnection.Co nnectionString =
... -
How to to redirect to the page when drop down list item is selected?
Hi,
public partial class Staff_LeaveNew : System.Web.UI.P age
{
protected void Page_Load(objec t sender, EventArgs e)
{
}
protected void DropDownList1_S electedIndexCha nged(object sender, EventArgs e)
{
if (DropDownList1. SelectedValue == "Death Leave")
{
Response.Redire ct("/Staff/nDeathLeave.asp x?staff_id="... -
Why cannot insert all the values in the database?
Hi,
The user_id is set as primary key.
"Cannot insert the value NULL into column 'user_id', table 'C:\DOCUMENTS AND SETTINGS\KAREN\ MY DOCUMENTS\VISUA L STUDIO 2005\WEBSITES\W EBSITE1\APP_DAT A\DB.MDF.dbo.us ers'; column does not allow nulls. INSERT fails.
The statement has been terminated." after debugging it.
protected void btnAdd_Click(ob ject sender, EventArgs e)
{
SqlConnection... -
anything wrong with line 29?
Hi,
Server Error in '/WebSite1' Application.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullRefe renceException: Object reference not set to an instance of an object.
... -
Incorrect syntax near the keyword 'user'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: Incorrect syntax near the keyword 'user'.
Source Error:
Line 35: MyAdapter1 = new SqlDataAdapter( MyCommand1);
Line 36: ... -
How to check the textbox?
Microsoft VBScript compilation error '800a03ee'
Expected ')'
/karen/MSS/Sourcing/SourcingSupplie r.asp, line 226
response.write( "<td><input type='checkbox' name='chkSuppli er" &count& "' checked value='" &rsReport.Field s("CPN")& "/" &rsReport.Field s("ManuID")& "/" &rsReport.Field s("SupplierName ")&... -
How to solve this error?
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/MSS/Feedback/FeedbackB.asp, line 61 -
The enter blanks cannot be cut off and the blanks still showed in the table of following page.
I need to use Next pagelink instead of submit input.
The bold link is the link to the following page.
Dim rsEmail, qryEmail
Dim res
Dim strInput, Count
Dim lines, x, outputText
lines = split(request(" txtCPN"), vbNewLine)
for each x in lines
if trim(x) <>...Leave a comment:
-
how to Send to Brokers Tier1, Tier2, Tier3 accordingly? No jump tiers .
--------------------------------------------------------------------------------
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr class="CatHeade r"><td> Sou rcing Selection<br></td></tr>
<tr class="filter"> <td><a href="SourcingB roker.asp?tier= tier 1&pro=<%=pro%>& email=<%=email% >&rt=<%=rt%>">< font... -
Thanks. no syntax error but it doesn't work. The empty fields still showed in the tables of following page.
Why?
[code=asp]
<%Function ListCPN()%>
<TEXTAREA class="project" name="txtCPN" cols="35" rows="10"><%Cal l trimLines%></TEXTAREA>
<%End Function%>
<%
Function trimLines...Leave a comment:
-
Hi Jared,
Thanks. I would like to trim off if there is enter blank in text area so that no empty fields are shown in the table of the following page.
Users can only enter CPN line by line but cannot press enter key for new line....Leave a comment:
-
Ensure user select Send to Brokers Tier1, Tier2, Tier3 accordingly?
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr class="CatHeade r"><td> Sou rcing Selection<br></td></tr>
<tr class="filter"> <td><a href="SourcingB roker.asp?tier= tier 1&pro=<%=pro%>& email=<%=email% >&rt=<%=rt%>">< font class="pageLink ">>>... -
how to get rid of the new line blanks in textarea?
<%Function ListCPN()%>
<!--<textarea class="project" name="txtCPN"></textarea>-->
<TEXTAREA class="project" name="txtCPN" cols="35" rows="10"></TEXTAREA>
<%End Function%>
No activity results to display
Show More
Leave a comment: