|
I did but now I am getting this:
Input string was not in a correct format.
here is my code:
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_add_new_volow_member", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.CommandTimeout = 300;
sql_command.Parameters.AddWithValue("param_full_name", txtSignupFullName.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_email_address", txtSignupEmailAddress.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_login_password", txtSignupPassword.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_record_guid", MySqlDbType.VarChar).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;
int result_rows = sql_command.ExecuteNonQuery();
|
|
|
|
|
give answer example(path of file)
|
|
|
|
|
Don't post just 'How to..' without any effort.
Replied you on how to save[^], learn and then try to do reverse of it.
|
|
|
|
|
From a folder on the server, or a folder on the users computer?
|
|
|
|
|
How to save any image or file in folder please give answer very soon in asp.net
|
|
|
|
|
|
How to save any image or file in folder please give answer very soon
|
|
|
|
|
|
|
when i use the gridview the i am unable to update and delete while select option work properly
|
|
|
|
|
And what did you do to update/delete? Until you share the effort made, any specific issue - how can anyone help you?
Select, Update, Delete are standard features whose implementations are widely discussed and shared on web, look at them and learn.
|
|
|
|
|
I need to create a pop up window in the top of the web page with the message"Please disable your pop up blocker" . Can you please help me out
Beni
|
|
|
|
|
Beniston1205 wrote: I need to create a pop up window in the top of the web page with the message"Please disable your pop up blocker" . Can you please help me out
One way around would be to create a div section, hidden by default, and to "pop it up" with JavaScript by toggeling the visibility. That way there will not be an additional window
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Beniston1205 wrote: create a pop up window
Popup are blocked by settings. You should use new child window. Use Window.Open[^] method to achieve it.
On button click, call this window.open client side using Javascript.
|
|
|
|
|
Hi,
I want to know how can I set a watermark for a textbox including when Password property is set to true?
|
|
|
|
|
Start here[^].
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
my problem is how to display selected item and a content of textbox in a gridview after a submit button dynamically (i will repeat more than 1 time) and so automatically the submit button will insert data in DB(entity framework)
the DropDownList1 is populated from db
to explain more this is my page :
<fieldset id="Item2">
<legend> Item Information</legend>
<br />
<br />
<center>
<table>
<tr>
<td>
<asp:Label ID="lblIemName" runat="server" >Item Name</asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"
AppendDataBoundItems="true" EnableViewState="true">
<asp:ListItem Value="0">--Select--</asp:ListItem></asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblQuantity" runat="server" >Quantité</asp:Label>
</td>
<td>
<asp:TextBox ID="txtQuantity" runat="server" Width="62px"></asp:TextBox></td>
<td><asp:ImageButton ID="btnAddItem" runat="server" Height="20" Width="20" ImageUrl="~/Images/Add.png" OnClick="btnAddItem12_click" />
</td>
</tr>
</table>
</center>
<br />
<br />
<center>
<asp:GridView ID="gvPurchasedItem" runat="server" AutoGenerateColumns="False" DataKeyNames="IDItemLinePurchased"
BackColor="Aquamarine">
<Columns>
<asp:BoundField HeaderText="CategoryName" ControlStyle-Width="250" DataField="CategoryName">
<ControlStyle Width="250px"></ControlStyle>
</asp:BoundField>
<asp:BoundField HeaderText="ItemName" DataField="ItemName" />
<asp:BoundField HeaderText="Quantity" DataField="Quantity" />
</Columns>
</asp:GridView>
</center>
</fieldset>
my behind code is :
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Populateddlitem();
}
}
void Populateddlitem()
{
DropDownList1.DataTextField = "ItemName";
DropDownList1.DataValueField = "IDItem";
DropDownList1.DataSource = LogicItem.Instance.GetItems();
DropDownList1.DataBind();
}
protected void btnAddItem_click(object sender, ImageClickEventArgs e)
{
// insert bloc
ItemLinePurchased res = null;
if (ID == 0)
res = new ItemLinePurchased();
else res = LogicItemLinePurchased.Instance.GetItemLinePurchasedByID(ID);
res.Quantity = Convert.ToInt32(txtQuantity10.Text);
res.IDItem = Convert.ToInt32(DropDownList1.SelectedItem.Value);
ViewState["ddl"] = DropDownList1.SelectedItem.Value;
res.IDPurchasesDoc = Convert.ToInt32(ViewState["PurchasesDocid"]);
res.State = "IsActive";
LogicItemLinePurchased.Instance.SaveItemLinePurchased(res);
int aaa = DropDownList1.SelectedIndex;
int bbb = Convert.ToInt32(Session["ddlState"]);
ViewState["id"] = res.IDItemLinePurchased;
//display grid view
gvPurchasedItem.DataSource = (from ItemLinePurchased in LogicItemLinePurchased.Instance.GetAllItemLinePurchased()
where ItemLinePurchased.IDItemLinePurchased == Convert.ToInt32(ViewState["id"]) && ItemLinePurchased.State == "IsActive"
select new
{
ItemLinePurchased.IDItemLinePurchased,
ItemLinePurchased.Item.Category.CategoryName,
ItemLinePurchased.Item.ItemName,
ItemLinePurchased.Quantity,
}).ToList();
gvPurchasedItem.DataBind();
}
any one have a solution to my problem post it and thanks
|
|
|
|
|
Hi,
I want to know how can I let Google do this for me? I mean the map AND and pics shown in the right side of the search result in this image:
http://www.rmc.bh/temp/geant.jpg
|
|
|
|
|
You can't change their UI.
No, that's a lie; you could install Greasemonky, write some JavaScript and remodel the page everytime it's loaded to your liking.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Did you read the Google Map API, and register for a key to use it?
The google maps web site has a complete how-to on how to use the mapping system complete with pre-written code.
|
|
|
|
|
Hi Sir/Madam,
I have done Login page in "asp.net mvc pattern".But im getting one runtime error like
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.ArgumentException: Column 'Emailid' does not belong to table Table.
So,Could any one help me on this
Here is my project solution and
database(table and StoredProcedure)
KRayudu
|
|
|
|
|
Well, I can't see your code, but the exception is pretty clear. You have a column called EmailID and it doesn't belong in the database table Table.
|
|
|
|
|
The error is simple.
The column Emailid does not exists in the table from which you are fetching the data.
If it exists then check the spelling. There might be problem in your SQL query also.
Thanks.
Tarun Mangukiya
|
|
|
|
|
how to fix the MachineToApplication error in web config
|
|
|
|
|