|
|
Hi
In my page i have one textarea the user will enter the values in this format
Material1 Materil2 Material3
1 150 200
2 27 35
I need to insert these values to database .plse help me.
|
|
|
|
|
Hi,
What are Material1 Materil2 Material3?
Are they column name..
If not then Split the string like
string[] lines = Regex.Split(TextBox1.Text, "\r\n");
himanshu
|
|
|
|
|
these are the cloumn names.if i am using split function "r\n" it is not working .Plse help me
|
|
|
|
|
Hi,
try this
string[] lines = Regex.Split(TextBox1.Text, "\r\n");
string sql ="Insert into "+"Table Name("+ lines[0].Replace(' ',',')+ ") values(";
for (int i=1;i<lines.Length;i++)
{
sql = sql + lines[i].Replace(' ', ',') + ")";
}
himanshu
|
|
|
|
|
Thanks a lot himanshu...
It is working fine....
Shiji 
|
|
|
|
|
try this example,
string s = TextBox1.Text;
string[] s1 = s.Split(new char[] { ' ' });
for (int i = 0; i < s1.GetUpperBound(0); i++)
{
Response.Write(s1[i]); //store this value to database instead
}
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
iam using a formview control in my project..
and iam trying to update fields of 2 tables using formview..
table1:Personal_details:
columns:P_id --->primary key
Emp_id-->foreign key
First_name
table2:Educational_qualification
columns:Eq_id ->primary key
Emp_id ->foreign key
Institute..
these 2 tables are connected by column Emp_id
My update command of formview control is:
UpdateCommand="Update [Personal_details] Set [First_name]=@First_name WHERE [P_id]=@original_P_id and[Emp_id]=@original_Emp_id and [First_name]=@original_First_name;
Update [Educational_qualification] Set[Institute]=@Institute WHERE [Eq_id]=@original_Eq_id and [Emp_id]=@original_Emp_id and [Institute]=@original_Institute"
>
<UpdateParameters >
<asp:Parameter Name ="P_id" Type ="string" />
<asp:Parameter Name ="original_P_id" Type ="string" />
<asp:Parameter Name ="original_Eq_id" Type ="string" />
<asp:Parameter Name ="First_name" Type ="string" />
<asp:Parameter Name ="Institute" Type ="string" />
<asp:Parameter Name="original_First_name" Type ="string" />
<asp:Parameter Name="original_Institute" Type ="string" />
<asp:Parameter Name ="original_Emp_id" Type ="string" />
</UpdateParameters>
when i try 2 edit values,old values are not gettin updated..i.e after clicking on the update link still the old values are gettin displayed..
plz suggest some solution..
modified on Thursday, June 18, 2009 2:26 AM
|
|
|
|
|
bind data to formview again
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
i did bind data to formview again,but still no change i.e the prob still persists
ne changes need to be made in the update command??
plzz suggest some alternative..
|
|
|
|
|
neone,,plzz suggest solution for my problem..
|
|
|
|
|
|
|
hi iam using webparts in my application now my doubt is how to implement webparts personaliztion.means different users will select different types of webparts how to show them individually for the next login
|
|
|
|
|
|
hi mr abhijit any example for this one
|
|
|
|
|
|
Hi,
I have got a weird problem opening a simple .aspx page using a Javascript on the click of ASP.net server control. It works perfectly fine in my local system.
Scenario: The application is deployed to production server. Clients get remote access to the application thr' Netilla platform which runs in https mode.
Code snippet:
Protected Sub LinkButton2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LinkButton2.Click
'Pop up new window for address collection...
Dim x As String
x = lstPickup.SelectedValue
Dim sb As New System.Text.StringBuilder()
sb.Append("<script language='javascript'>")
sb.Append("alert('" & x & "');")
sb.Append("window.open('CollectionAddress.aspx?selectedPickup=" + x + "', 'CollectionAddressPage',")
sb.Append("'width=500, height=500, menubar=yes, resizable=no');")
sb.Append("</script>")
Dim t As Type
t = Me.GetType()
If Not ClientScript.IsClientScriptBlockRegistered(t, "PopupScript") Then
ClientScript.RegisterClientScriptBlock(t, "PopupScript", sb.ToString())
End If
End Sub
The application URL looks is http://myApplication/Reserve.aspx but when browsed using Netilla it looks like..
https://ras.abc.co.uk/,host=192.168.145.32,port=80,proto=http/myApplication/Reserve.aspx
Okay..now the funny thing is that the same code works if it is copied to another new pages with nothing but just the above code and a button.
Weird.
Any help would be appreciated.
Many thanks
Milan G
Milan
|
|
|
|
|
Hi all,
i want to open an existing word document in a folder in the project,path of that file is stored in oracle table.
When i click a link button a query should be executed to take the corresponding path,then with that path the file should be opened.
i tried like this..
Private Sub Linkbutton6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Linkbutton6.Click
Dim str As String
Dim command As String = "SELECT FILENAME FROM S_TR_BUILDDATA A WHERE 1= (SELECT COUNT(DISTINCT B.DATEOFBUILD ) FROM
S_TR_BUILDDATA B WHERE A.DATEOFBUILD <=B.DATEOFBUILD) "
Dim DFmenu As DataSet = Me.ExecuteSql(command)
str = DFmenu.Tables(0).Rows(0).Item(0)
System.Diagnostics.Process.Start(str)
' Response.Redirect(str)
End Sub
its getting filled in dataset..
but the file is not opening..
what shall i do???
thanks n regards,
kums
|
|
|
|
|
kvalli wrote: its getting filled in dataset..
but the file is not opening..
And will never open this way.
kvalli wrote: what shall i do???
System.Diagnostics.Process.Start(str)
' Response.Redirect(str)
Response.Redirect(Server.MapPath(str));
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hi All,
Can anyone plse tell me tat,wat is the diffrence between calling javascript function throuh onclient click of button(client side) and
adding attribute to tat button(server side)?
ex:
<asp:button accesskey="C" id="btnClear" onclientclick="return Validate()" runat="server" text="Clear" <="" asp:button="">
btnClear.Attribute.Add("OnClick",return Validate()" )
Regards
Lijo
|
|
|
|
|
Doesn't the name suggest the meaning.
OnClick is used to trigger some server method(C#, VB.Net) where as OnClientClick will fire the Client methods(Javascript)
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
For dynamic controls, using Control.Attribute.Add() you can add client side script.
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
Both are same. In case of OnClientClick the asp:Button will render the a submit button, and OnClick will evaluate your javascript. Same as Attributes.add
|
|
|
|
|
Hi,
I have made a small application in ASP.Net in which whenever the user registers a mail is send to his/her account.
It is working sucessfully on my Local machine.
But when i deploy it on the server it is giving some error.
Following is the snippet from web.config
<system.net>
<mailSettings>
<smtp from="admin@formbag.com">
<network host="someipaddress" port="25" userName="username" password="password" defaultCredentials="true" />
</smtp>
</mailSettings>
</system.net>
Is there some settings I am missing on server or something else.
Thanks in advance.!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
