Bulk Insertion to DB - C# Discussion Boards

Re: Post Request

Support12326-Sep-06 23:41

Support123

26-Sep-06 23:41

Would this:

Salon.Library.SystemDefault sysdef = new SystemDefault();<br />
			sysdef.LoadData();<br />
			ASCIIEncoding encoding = new ASCIIEncoding();<br />
			string postData = "username=Whatever&password=BlahBlah&source_id=" + Convert.ToString(sysdef.ID) + "&message=" + Message + "&msisdn=" + CellNo;<br />
            byte[] data = encoding.GetBytes(postData);<br />
<br />
			//Prepare Web Request...<br />
			HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create("http://bulksms.2way.co.za:5567/eapi/submission/send_sms/2/2.0?");<br />
			myRequest.Method = "POST";<br />
			myRequest.ContentType = "application/x-www-form-urlencoded";<br />
			myRequest.ContentLength = data.Length;<br />
			Stream newStream = myRequest.GetRequestStream();<br />
<br />
			//Send the Data<br />
			newStream.Write(data,0,data.Length);<br />
			newStream.Close();

Am i doing this correctly? I saw this in an example on the net...

is this the same as the top part but the top part is the post part?

string Argu = "http://bulksms.2way.co.za:5567/eapi/submission/send_sms/2/2.0?username=Whatever&password=BlahBlah&source_id=" + Convert.ToString(sysdef.ID) +"&message=" + Convert.ToString(Message) + "&msisdn=" + Convert.ToString(CellNo);<br />
			HttpWebRequest Request;<br />
			StreamReader ResponseReader;<br />
			Request = ((HttpWebRequest)(WebRequest.Create(Argu)));<br />
			ResponseReader = new StreamReader(Request.GetResponse().GetResponseStream());

Thank you in advance...

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Great, now one more thing and then its perfect...

Support12327-Sep-06 0:16

Support123

27-Sep-06 0:16

Okay i got it to work with this code...

Salon.Library.SystemDefault sysdef = new SystemDefault();<br />
sysdef.LoadData();<br />
ASCIIEncoding encoding = new ASCIIEncoding();<br />
string postData = "username=Whatever&password=BlahBlah&source_id=" + Convert.ToString(sysdef.ID) + "&message=" + Message + "&msisdn=" + CellNo;<br />
byte[] data = encoding.GetBytes(postData);<br />
<br />
//Prepare Web Request...<br />
HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create("http://bulksms.2way.co.za:5567/eapi/submission/send_sms/2/2.0?");<br />
myRequest.Method = "POST";<br />
myRequest.ContentType = "application/x-www-form-urlencoded";<br />
myRequest.ContentLength = data.Length;<br />
Stream newStream = myRequest.GetRequestStream();<br />
<br />
//Send the Data<br />
newStream.Write(data,0,data.Length);<br />
newStream.Close();

But how do i know when an error occurs with this example...
Will this allow me to use more than 2083 caracters in the uri or will it give me an error like with the previous attempt to send the uri request with the get and not the POST. How can i test this, this method does not bring back errors...

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

RichTextbox

izakfick26-Sep-06 22:16

izakfick

26-Sep-06 22:16

Good morning to all. Could anyone please tell me how to syncronize two richtextbox scroll positions? I'm now already on dangerous caffiene levels and running out of ideas.

I'm overriding WndProc to catch the Scroll event and I'm using GetScrollInfo() to
return position data and-so-forth but I'm having no luck with setting or syncronizing the two richtextboxe scrollbars. Please help.

An example that i got of the net shows me how to move the scrollbar up and down but not ultimately to a specific position.

Regards and many thanx

Re: RichTextbox

Nader Elshehabi27-Sep-06 1:18

Nader Elshehabi

27-Sep-06 1:18

Hello

You can change the caret position in the second RichTextBox accroding to the first scrollposition, then use RichTextBox.ScrollToCaret() method to scroll accrodingly.

Regards

How to set windows default sound card devices in c#.NET

YogeshRT26-Sep-06 22:12

YogeshRT

26-Sep-06 22:12

Hello
how to set windows default sound card devices in c#.NET

Yogesh_T

assigning string to dataset

saqib8226-Sep-06 21:49

saqib82

26-Sep-06 21:49

How can i assign a string to DataSet?

sAqIb

Re: assigning string to dataset

_AK_26-Sep-06 23:16

_AK_

26-Sep-06 23:16

Why you want to store into a dataset? Sigh | :sigh:

Best Regards,
Apurva Kaushal

Bulk Insertion to DB

meeram39526-Sep-06 21:41

meeram395

26-Sep-06 21:41

Hi,

I have a problem. I have a dataset contains 8 tables. Each table contains 25,000-30,000 records. I want to insert all the records at a time. There is no primary key or foreign key constarints or no conditions to check. Just dumping to database. That's all. For that I used the below code. But no insertion is happening. Can anybody help please?

SqlDataAdapter PEOQCAdap=new SqlDataAdapter();
SqlCommand inscommand=new SqlCommand();
inscommand.Connection=SqlCon;

inscommand.CommandType=CommandType.StoredProcedure;
inscommand.CommandText="INSERT_NOISSUELEVEL";

inscommand.Parameters.Clear();
inscommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@VALUE1",System.Data.SqlDbType.VarChar,50,"VALUE"));
inscommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ASTNDA",System.Data.SqlDbType.BigInt,8,"AST_FOR_NDA_ID"));
inscommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ANALAYST",System.Data.SqlDbType.VarChar,50,"CREATE_BY"));
inscommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CREATEDATE",System.Data.SqlDbType.NVarChar,50,"CREATE_DATE"));
inscommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@NDAID",System.Data.SqlDbType.BigInt,8,"NDA_ID"));
inscommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@COMPANY",System.Data.SqlDbType.VarChar,50,"COMPANY_NAME_AT_OFFER"));

PEOQCAdap.InsertCommand=inscommand;
PEOQCAdap.Update(ds.Tables[0]);

Any sort of help is great!!!

Thanks

Raja Raman S
Reuters India Pvt.Ltd.
Bangalore

how to read .resx file

Tamimi - Code26-Sep-06 21:13

Tamimi - Code

26-Sep-06 21:13

hi could someone please tell me how to read .resx file from the code.
note : in a web form

thank you all

Tamimi - Code

Re: how to read .resx file

Stefan Troschuetz26-Sep-06 21:26

Stefan Troschuetz

26-Sep-06 21:26

Resource files are Xml files, so you could use XmlTextReader or XmlDocument types.
If you want to access the information without dealing with Xml take a look at the ResourceManager class.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: how to read .resx file

Tamimi - Code26-Sep-06 22:04

Tamimi - Code

26-Sep-06 22:04

thank you

Tamimi - Code

Transparent Label

morteza5726-Sep-06 21:11

morteza57

26-Sep-06 21:11

Hi, I want create a Label with transparent Color as "Color.FromArgb(40, 0, 0, 255)"
how can I do?
Please help me

Re: Transparent Label

Guffa26-Sep-06 21:34

Guffa

26-Sep-06 21:34

Please don't cross post.

---
b { font-weight: normal; }

Re: Transparent Label

Nader Elshehabi27-Sep-06 1:28

Nader Elshehabi

27-Sep-06 1:28

Hello

You'd have to inherit your own class from class Label, and in your class call

SetStyle(ControlStyles.SupportTransparentBackColor, true);

Then change the BackColor as you like.

Regards

How to host multiple channels in an exe ??? .NET Remoting [modified]

Waqas Nasir26-Sep-06 21:06

Waqas Nasir

26-Sep-06 21:06

Hi,

Does any body know how to host multiple server channels in an exe, or is it possible to do that... I have a windows service and I need at least 2 server channels when I make a second call to TcpServerChannel constructor then and exception comes that the tcp channel is already registered...

Can any body help...

Thanks in advance...

Regards.

-- modified at 3:18 Wednesday 27th September, 2006

returning values from webservice

saqib8226-Sep-06 20:41

saqib82

26-Sep-06 20:41

I have a webservice through which i have to access a specific folder and then hae to retrieve the list of some specific files (file name, date created, last modified) from that folder. I have done it successfully. Now i want to access this method of webservice in my c# application. I am confused to access this method. I am not sure what to return and how to return values from that method of webservice. I want to use file name, date created, and last modified date from that webservice to populate ListView in the C# application. can anybody help me by telling me what should be the return value of that webmethod of webservice?

Regards

sAqIb

Re: returning values from webservice

Stefan Troschuetz26-Sep-06 21:33

Stefan Troschuetz

26-Sep-06 21:33

Create a simple class that encapsulates the information and return an array og this class.

public class Info
{
    public string Name;
    public DateTime Created;
    public DateTime LastModified;
}

[WebMethod]
public Info[] GetFiles()
{
    return new Info[2];
}

Read items from list box

eswarattaluri26-Sep-06 19:30

eswarattaluri

26-Sep-06 19:30

Hai,

I am eswar i am trying to read the items from the list box here in list box we can select multiple items how to read these multiple items from the listbox can any body help in this situation.

regards,
Eswar.

Re: Read items from list box

myfend_liang26-Sep-06 19:41

myfend_liang

26-Sep-06 19:41

code> private void Form1_Load(object sender, System.EventArgs e)
{
for(int i=0;i<10;i++)
{
listBox1.Items.Add("this is" + i.ToString());
}
listBox1.SelectionMode = SelectionMode.MultiExtended;
}

private void button1_Click(object sender, System.EventArgs e)
{
for(int i=0;i<listbox1.selecteditems.count;i++)
{
="" messagebox.show(listbox1.selecteditems[i].tostring());
="" }
="" }<="" code="">

Re: Read items from list box

myfend_liang26-Sep-06 19:42

myfend_liang

26-Sep-06 19:42

private void Form1_Load(object sender, System.EventArgs e)
{
for(int i=0;i<10;i++)
{
listBox1.Items.Add("this is" + i.ToString());
}
listBox1.SelectionMode = SelectionMode.MultiExtended;
}

private void button1_Click(object sender, System.EventArgs e)
{
for(int i=0;i

How to show popup window in loop

YogeshRT26-Sep-06 19:03

YogeshRT

26-Sep-06 19:03

Hello
I have to show popup window using loop ,
On button click event if I call ShowInfoNotification() method the popup window comes,
But I have to show this in loop.
How can I do this,may I use thread here? how can I use sleep() method

private Utility.NotifierX objNotifierX = new Utility.NotifierX();
private void btnSubmit_Click(object sender, System.EventArgs e)
{

objNotifierX.ShowInfoNotification("test");
}

Yogesh_T

I want c# code with Windows Task manager (Networking)

seasone cheng26-Sep-06 18:39

seasone cheng

26-Sep-06 18:39

I want c# code with Windows Task manager (Networking)
same this picture

http://img86.imageshack.us/img86/1006/net2bf6.jpg[^]

so thank you.

Re: I want c# code with Windows Task manager (Networking)

lmoelleb26-Sep-06 23:04

lmoelleb

26-Sep-06 23:04

Good luck. Let os know if you need any help by asking a specific question when you are stuck. Smile | :)

implementing multiple class in a project

Harikrk26-Sep-06 18:15

Harikrk

26-Sep-06 18:15

I have three 3 projects in my solution. One for connecting to database. One for giving the general class files and one front end. In connection project i have defined two class for different connections. I want to create a object of this classes in the general project dynamically based on a value in the app.config file. where can i give this object creation? i tried in main function, but as it in front end project its not working.
Plz help

regards
Hari

Inherting from master forms dynamically

Harikrk26-Sep-06 18:08

Harikrk

26-Sep-06 18:08

Hi guys
i am doing a desktop application in C#. I have two master forms. in a child form i want to inhert any one of a master form dynamically based on a value (say msdesign). How can i do this?

Regards
Hari
aspspider.net/rkharikrishnan

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.