Hey Experts ;-) I have a littel problem maybe som of experts can help me: I have this code to select somthing for sql database, now i need to send this query like email, how can i send the Dataset like email ? The code: int Customerid =(int)(dr["CustomerId"]); string customer = dr["Customer"].ToString(); SqlCommand cmd2 = new SqlCommand("licensesexpireddato", con); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@KundeID", Customerid); DataSet ForDataset = new DataSet(); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); da2.Fill(ForDataset); cmd2.ExecuteNonQuery(); I hope i can help me, sorry my english.

you are the man ;-)

Hey everbody I have a big problem to upload one csv fil to mysql database. i have a big csv file with many records and column Eks.: ArticleNo ManArticleNo DescShort DescLong Manufacturer Price Stock 642 0993A001 BJ-642/black 790sh f BJ300 330 Canon blækpatron, sort (BJI-642BK) Canon 97,11 0 665 1009A001 BJC-643/black f BJC-800 820 880 Canon blækpatron, sort (BJI-643BK) Canon 157,43 0 673 1012A001 BJC-643/yellow f BJC-800 820 880 Canon blækpatron, gul (BJI-643Y) Canon 203,42 0 3131 51604A HP Ink Cart/Black f ThJet QJet+ f plain HP blækpatron, sort (CJ-3A) Hewlett Packard 57,91 115 3135 51605R HP Ink cart/red f Think- Quietjet HP blækpatron til ThinkJet/QuietJet, magenta Hewlett Packard 63,63 0 i load the file like this StreamReader input = new StreamReader(@"c:\test.csv"); string inputLine = ""; while ((inputLine = input.ReadLine()) != null) { but now i need just to take ManArticleNo and Price from the inputLine my input line has all the row, how can i split or somthing to take just that column i need ? string tr = inputLine.?(?); } input.Close();

Thanks but do you have som code in c# i can use ?

Hello everybody First sorry my english but i need som help. I have a website where i sal computer and other stof, every day i get i xls. file from one company with price list model number, description and other thing. Every product in my website has parnumber: thats unik. So i want to make a function in c# to update the price in mysql database because the price changes every day. How can i make a function like update table_name from c:\test.xls (take just price and partnumber from xls file ) where partnumber=(partnumber from xls) ? I hope really much you can help me.

somtimes you can use lot of time with som easy code

Now it works.. thank thanks very much..

i use a culture en US ? in my web.aspx project.

Thanks very mutch blackjac But it still not work if i use dot ex. 1.4 then it takes it like 14 and if i use 1,4 coms with error "No value associated with 1,4"

thaks very mutch but you do not have som method like double.parse(textbox.text) or somthing like that som can help me out of here. I used Inof.Lundin.Math but this cannon add decimal this can just add 1+1 = 2 but not 1+1,4 = 2,4

Hey I have a textbox with values = 1 + 1,3 + 1 + 7 How can i calculate that so when i push the button calculate will give the result = 10,3 Thanks very very mutch its really importing

thanks very much dave.. i was wery big help. but how shut i get the application name which user has clict on. thanks very mutch

Hey i trying to make a application thats run on background and write to a file how long user was running a application Ex. if user click on word then write to a file user clict on word time: 11:01 or somthing like that. and if user clickt on internet explorer then write to file user clickt on internet explorer time: 11-03. i hope you can help me. Sorry my english,

i need to se if my rquest from the page is succses like a posted the first topic in php .. thanks christian.

// the problem is her... gv_reply = httpRequest(gv_url); if (gv_reply == "") { ' If the reply contains the tag <succes> the SMS has been sent. Response.Write "The message has been sent. Server response: " & gv_reply } else ' If not, there has been an error. Response.Write "The message has NOT been sent. Server response: " & gv_reply //To here..

with ?

thanks... but i have problem with httprequest or httpresponse its not working.. Error 8 'System.Web.HttpResponse' is a 'type' but is used like a 'variable'

[Message Deleted]

I need to replace this caracter " to nothing in my database but its not work. her som code. SqlCommand cmd1 = new SqlCommand("update c5 set name= replace(name,'"',''), conn); but its make error on visual studio but in micrsoft Sql Server managment its work fine. Error: Error 2 Too many characters in character literal ) expected ; expected ; expected Hope i can help me..

Hey I have created a metode to create RadiobuttonList dynamically but when i show it in my page end i chec them to false or true and when i click the button all radiobutton is coming back to true. I have a function to read wgat user have selected : Hope i can help. her is som code to create radiobuttonlist: foreach (DataRow dr in ds.Tables[0].Rows) { Label li = new Label(); System.Web.UI.WebControls.ListItem ls = new System.Web.UI.WebControls.ListItem(); RadioButtonList rl = new RadioButtonList(); rl.Items.Add(new System.Web.UI.WebControls.ListItem("Inkl", dr["Type"].ToString())); rl.Items.Add(new System.Web.UI.WebControls.ListItem("Eks", dr["Type"].ToString())); rl.RepeatDirection = RepeatDirection.Horizontal; Panel2.Controls.Add(li); Panel2.Controls.Add(rl); //tilføjer dem til panelet } then when i click a button hwo called checkthevalue, i called this metode: foreach (Control cr in Panel2.Controls) { if (cr is RadioButtonList) { RadioButtonList rb = (RadioButtonList)cr; foreach (System.Web.UI.WebControls.ListItem ls in rb.Items) { if (ls.Selected && rb.SelectedItem.Text == "Eks") { //this ad a line to pdf file document.Add(new Paragraph("-" + rb.SelectedItem.Value.ToString(), FontFactory.GetFont(FontFactory.TIMES_ROMAN, 12))); } } } } Hope i can help me.