|
Can anyone tell me how to insert values from 2 different Text Boxes into a single Column of a database table as different rows.
Any help will be greatly appreciated.
Thanks in Advance
Imran
Imran
|
|
|
|
|
Why are you re posting.[^]. I will give you the same answer as you previously got, do 2 separate inserts, one for each textbox into the same table.
|
|
|
|
|
Thanks, actually i need to have any number of dynamically created text boxes when ever user clicks on more button. From that i need to fetch the values and save it into the database table in a single column as different rows.
Again when showing the data in the text box after binding the text boxes that particular record should be shown in that particular text box from where it has been fetched.
Thanks
Imran
|
|
|
|
|
Ok, in your database table you will need to associate an Id value with each text value, add an Id column with an auto generated id.
After you bind the textboxes and submit the form you can loop through the textboxes and
check for an Id value, if none exists then you can insert the new text value as a new row.
If an Id value exists then it already exists in the database so you can use the Id value to Update the existing text value.
|
|
|
|
|
Thank You very much
Could you please help me with a small sample code for doing this.
Thanks
Imran
|
|
|
|
|
If I write it for you then you won't learn anything. You have the basic concepts so you can try to write it yourself, if you get stuck again on a specific problem then post it as a separate question with as much detail as possible.
|
|
|
|
|
Ok thanks a lot, i will try. Currently i have written code like this to insert record
private void InsertRecord()
{
try
{
string strInsert = "insert into Quotation" +
"(JobNum, CompNameAdd)"
+ "values('" + this.txtJobNum.Text + "','"
+ this.txtCompNameAdd.Text + "')";
MySqlCommand command = new MySqlCommand(strInsert, Quotation.con);
Quotation.dQuotationAdapter.InsertCommand = command;
//Insert new record
Quotation.dQuotationAdapter.InsertCommand.ExecuteNonQuery();
MessageBox.Show("New Record Saved Successfully");
RefreshRecord();
ClearTextBoxes();
this.txtCompNameAdd.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
But in this code i can not insert values from two text boxes into a single column
Thanks
Imran
|
|
|
|
|
This is the same code you had in your previous post earlier today[^].
This code is executing 1 Insert statement, which inserts 2 values into the 2 columns of 1 row.
You need to write a statement which insert 1 value into 1 row. You then need to call this statement for each value you want to Insert. This will create a single column of values.
|
|
|
|
|
Hi
Can any1 quickly explain to me how to upload files to a web server using Visual Web Developer 2005?
I know how to do it in Dreamweaver
I have the IP address username and password
cheers
|
|
|
|
|
I don't have Visual Web Developer but on Visual Studio there is a Publish Web Site option under the Build menu. If you don't have that then you can use something like SmartFTP to upload to your web server.
|
|
|
|
|
Hi
There is no publish facility in visual web developer
Is there no way I can use VWD to upload files, i dont realy want to use an external client such as smartftp
thanks anyway
|
|
|
|
|
I guess Visual Web Developer was only ever going to provide basic functionality and leave out the nice-to-have functions, it is a free tool after all, and understandably MS want you to upgrade to the full version of Visual Studio to get your mula. 
|
|
|
|
|
Hey
OK so I have downloaded smart ftp as my ftp client and have uploaded the files
however now they are just showing as the code and not as an actual page
any reasons for this?
cheers
|
|
|
|
|
Are you sure your host supports the version of ASP.NET you are using?
|
|
|
|
|
I have a datatable with field of datatype image.In that field i am storing images converted into bytes.When i try to modify it i am not gave any image and save it.Then the filed value is NULL.again i try to modify by gaving any image ,then an exception of string or binary truncated occurs.why this error occur.
|
|
|
|
|
Please relpy .its urgent.
|
|
|
|
|
Ok sir. Sorry to delay. Can you please explain the methods u tried to store the image?
|
|
|
|
|
if (Upload_Logo.HasFile)
{
Stream ms = Upload_Logo.PostedFile.InputStream;
int filelength = Upload_Logo.PostedFile.ContentLength;
string contenttype = Upload_Logo.PostedFile.ContentType;
byte[] image = new byte[filelength];
int length = ms.Read(image, 0, filelength);
insunit.SaveUnitDetails(Txt_UnitName.Text, Txt_ShortName.Text, Txt_Location.Text, image, DdlStreamList.SelectedValue, TxtStdperClass.Text, username.Trim(), date);
}
This is the method i used to store the image.By converting the uploaded image into byt and save it thesaveunitdts is the class file
|
|
|
|
|
As u told me i send the code to u sir.Then why dont u reply.please help me urgently.
|
|
|
|
|
Hi.
This is from Chandrakanth.
Actually in my page i was added Menu.
I have Binded Data through SiteMap Provider.
My Menu are ADMIn ,USERS,sALES,rEPORTS.
uNDER aDMIN -loGIN,RESET PASSWORD
UNDER USERS -USERADD, USERMODIFY
UNDER SALES - SALESREPORTADD
UNDER REPORTS - REPORT1
NOW I HAVE ONE Drop Down List , TextBox And One Button.
Drop Down Items are populated from Database.
Drop Down Items are like -- New Menu, AddUsers,Master Records
Now i want to Select Items from DropDown(Ex... AddUsers)
After that i have enter Name of Menu(LIke Admin, Users,Sales,Report) this choice depending upon User.
suppose i enter in the Text box like "Admin"
Here after user click Add Button ...
What ever i select from DropDown(AddUsers)
that shold be added in the Main Menu Based on entering the Name of the Menu Name in the TextBox.
Ex in the Dropdown i Have seleced --- addUsers
in the Text box i have enterred --- Admin by clicking button
Under Admin
AddUsers Shold be add.
Can any one Give me some suggestion ont this.
Thnks andRegards
Chandraknth
Chandrakanth
|
|
|
|
|
Where is your menu coming from ? There's no menu built into ASP.NET AFAIK.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi
Mr Christian Graus
I have Taken Menu Control in (2.0)
And My Name of the Page is Menu.aspx
that coding is
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server" >
<asp:Menu ID="Menu1" runat="server" Font-Names="Verdana" Font-Size="0.8em"
ForeColor="White" Height="14px" Orientation="Horizontal"
StaticEnableDefaultPopOutImage="False" StaticSubMenuIndent="10px"
Style="clear: right; display: inline; font-weight: bold; list-style-position: outside; font-size: 15pt; float: none; text-transform: capitalize; color: purple; list-style-type: circle; text-align: justify; text-decoration: underline"
Width="100%" > <%--DataSourceID="SiteMapDataSource1" --%><StaticMenuStyle BackColor="#01145a" />
<StaticMenuItemStyle Font-Size="Small" HorizontalPadding="5px" VerticalPadding="2px" Font-Bold="true" />
<DynamicHoverStyle BackColor="#cccdd5" ForeColor="#01145a" Font-Underline="true" Font-Bold="true" />
<DynamicMenuStyle BackColor="#cccdd5" BorderColor="#ff0000" Font-Bold="true" />
<StaticSelectedStyle BackColor="Fuchsia" BorderColor="Blue" ForeColor="White" Font-Bold="true" />
<DynamicSelectedStyle BackColor="Lime" BorderColor="White" Font-Bold="true" />
<DynamicMenuItemStyle HorizontalPadding="5px" VerticalPadding="2px" Font-Bold="true" />
<StaticHoverStyle BackColor="#01145a" ForeColor="White" />
</asp:Menu>
<asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" ShowStartingNode="false" />
<table width="100%" >
<tr>
<td align="center" >
<asp:DropDownList ID="ddlMenu" runat="server" Width="200px" Height="22px">
<asp:ListItem Value ="Select">--------------------Select-------------------</asp:ListItem>
<asp:ListItem Value ="Sub1">Sub1</asp:ListItem>
<asp:ListItem Value ="Sub1">Sub2</asp:ListItem>
<asp:ListItem Value ="Sub1">Sub3</asp:ListItem>
<asp:ListItem Value ="Sub1">Sub4</asp:ListItem>
<asp:ListItem Value ="Sub1">Sub5</asp:ListItem>
<asp:ListItem Value ="Sub1">Sub6</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td align="center">
<asp:TextBox ID="txtMenu" runat="server" Width="180px" Height="20px"></asp:TextBox>
<asp:Button ID="btnMenu" runat="server" Width="70px" Text="AddMenu" onclick="btnMenu_Click" />
</td>
</tr>
</table>
</asp:Content>
And I have Bounded data through Web.SiteMap thst coding is
<siteMap>
<siteMapNode title="Default" description="Home" url="menu.aspx" >
<siteMapNode title="Admin" description="Admin" >
<siteMapNode title="LogIn" url="~/KotakLogin/LogIn.aspx" />
<siteMapNode title="ChangePassword" url="~/KotakLogin/ChangePassword.aspx" />
<siteMapNode title="ResetPassword" url="~/KotakLogin/ResetPassword.aspx" />
</siteMapNode>
<siteMapNode title="Users" description="Users" >
<siteMapNode title="Default ErrorPage" url="DefaultErrorPage.aspx" />
<siteMapNode title="Query Builder" url="~/Admin/QueryBuilder.aspx" />
<siteMapNode title="View QueryBuilder" url="~/Admin/ViewQueryBuilder.aspx" />
</siteMapNode>
<siteMapNode title="Sales" description="Sales" >
<siteMapNode title="SecurityQuestion" url="~/KotakLogin/SecurityQuestion.aspx" />
<siteMapNode title="FisrtLoginChangePassword" url="~/KotakLogin/FisrtLoginChangePassword.aspx" />
</siteMapNode>
<siteMapNode title="Reports" description="Reports" >
<siteMapNode title="RequestForUserRegistration" url="~/KotakLogin/RequestForUserRegistration.aspx" />
<siteMapNode title="UserRegistrationApproval" url="~/KotakLogin/UserRegistrationApproval.aspx" />
</siteMapNode>
<siteMapNode title="Questions" description="Questions" >
<siteMapNode title="Image Viewer" url="~/Admin/ImageViewer.aspx" />
<siteMapNode title="Search" url="Search.aspx" />
</siteMapNode>
</siteMapNode >
</siteMap>
Can any one give me suggestion for this on how to Follow
Thanks And Regards
chandrakanth
Chandrakanth
|
|
|
|
|
You can make changes to what appears in the menu at runtime by manipulating the nodes in the OnMenuItemDataBound event, however persisting changes to the web.sitemap file is not so easy as this file is cached and the changes will not be visible until the application restarts.
|
|
|
|
|
hi friend
i am using thread with COM object but i gated all simple object when thread start but COM object not find. how i manage com object with thread please help me.
Piyush Vardhan Singh
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
