Re: how to make check of a value in a textbox is integer or string? - C# Discussion Boards

Re: Need help with updating SQL server express DB from c# - Done IT!

24-Sep-09 9:02

Thank you you help, below is the working code.
I am sure there will be smart ways to do this, but I am just happy to get it working.

The next problem (just incase you can help) is, is in another bit of code I use Textbox.text instead of the dr[col..], however the string is too long for the field and i get an error. even when i use substring(0,10). How can I auto sence the max field width and truncate it.

also (as i have you here) i would like to apply some formating to a cell on a DataViewGrid ie date dd/mm/yyyy.

            private void btnSaveAllChangesMadeToAllLogsSoFar_Click(object sender, EventArgs e)
            {

                  SqlConnection cn = new SqlConnection(LoginForm.gb_strConnection);
                  cn.Open();

                  DataTable dt = new DataTable();
                  dt = gl_Dataset.ds.Tables["tblQls"];
                  string strCommand = "";

                  foreach (DataRow dr in dt.Rows)
                  {
                        strCommand = "UPDATE tblQLs SET " +
                              "colClosedDate = '" + dr["colClosedDate"].ToString() + "', " +
                              "colAppealReason = '" + dr["colAppealReason"].ToString() + "', " +
                              "colAppealUpheld = '" + dr["colAppealUpheld"].ToString() + "', " +
                              "colFinalActionTaken = '" + dr["colFinalActionTaken"].ToString() + "', " +
                              "colNotes = '" + dr["colNotes"].ToString() + "' " +
                              "WHERE [colErrByUserID] = '" + dr["colErrByUserID"].ToString() + "' " +
                              "AND [colQLID] = '" + dr["colQLID"].ToString() + "' ";

                        SqlCommand cmd = new SqlCommand(strCommand);
                        cmd.Connection = cn;

                        cmd.ExecuteNonQuery();
                  }
                  cn.Close();
            }

PIEBALDconsult24-Sep-09 9:23

Re: Need help with updating SQL server express DB from c# - Done IT!

24-Sep-09 9:23

PLEASE use a parameterized query:

SqlCommand cmd = cn.CreateCommand ( "UPDATE tblQLs SET colClosedDate=@colClosedDate ... " ) ;
 
(Create and add parameters...) (It shouldn't require ToString())
 
foreach ( ... )
{
    (Set parameter values...)
    cmd.ExecuteNonQuery() ;
}

Mark-123456789 wrote:
too long for the field and i get an error

I'd have to see it.

Mark-123456789 wrote:
How can I auto sence the max field width and truncate it.

You'd have to access the schema, which isn't very difficult.

Mark-123456789 wrote:
DataViewGrid ie date dd/mm/yyyy

I don't use DataViewGrids so I don't know off hand.

Mark-12345678924-Sep-09 9:29

Re: Need help with updating SQL server express DB from c# - Done IT!

24-Sep-09 9:29

You wish is my command.

{
                  SqlConnection cn = new SqlConnection(LoginForm.gb_strConnection);
                  cn.Open();

   // this bit is me trying a work-around-----------------------------
                  char[] test = new char[15];
                  txbColPolicyRef.Text = txbColPolicyRef.Text.Trim().ToUpper();
                  int intLen = txbColPolicyRef.Text.Length;
                  if (intLen > 15) intLen = 15;
                  test = txbColPolicyRef.Text.Trim().ToUpper().Substring(0, intLen ).ToCharArray();
   // ------------------------------------------------------------
                  string strCommand = "INSERT INTO tblQLs (colQLID, colCreatedDate, colClosedDate, colErrDate, " +
                                                "colPolicyRef, colCreatedByUserID, colErrDescription, colErrByUserID, " +
                                                "colAppealReason, colAppealUpheld, colFinalActionTaken, colNotes, colUserTeam) " +
                                                "VALUES (" +
                                                "'16', " +
                                                "'x', " +
                                                "'" + test + "', " +
                                                "'" + @txbColCreatedByUserID.Text.Trim().ToUpper() + "', " +
                                                "'" + @cbColErrDescription.Text.Trim().ToUpper() + "', " +
                                                "'" + @txbColErrByUserID.Text.Trim().ToUpper() + "', " +
                                                "'x'," +
                                                "'" + @txbColErrDate.Text.Trim() + "', " +
                                                "'x','x','x','x', " +
                                                "'" + @txbColUserTeam.Text.Trim().ToUpper() + "') ";

                  SqlCommand cmd = new SqlCommand(strCommand);
                  cmd.Connection = cn;

                  cmd.ExecuteNonQuery();

                  cn.Close();
            }

PIEBALDconsult24-Sep-09 9:44

how to make check of a value in a textbox is integer or string?

24-Sep-09 9:44

Maybe check this[^] out.

Particularly my rendition of ExecuteNonQuery and ListColumns.

bounik22-Sep-09 13:41

bounik

22-Sep-09 13:41

My friends i need help about this issue can anyone help me Frown | :(

Re: how to make check of a value in a textbox is integer or string?

Wes Aday22-Sep-09 13:44

Wes Aday

22-Sep-09 13:44

You can use Char.IsDigit to see if a character is a digit or other character.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns

Help humanity, join the CodeProject grid computing team here

Re: how to make check of a value in a textbox is integer or string?

bounik22-Sep-09 14:16

bounik

22-Sep-09 14:16

thanks for your help problem solved

Re: how to make check of a value in a textbox is integer or string?

Luc Pattyn22-Sep-09 14:16

Luc Pattyn

22-Sep-09 14:16

Hi,

you can use the TryParse() method of int, uint, long, ulong depending on the range you want to support; and some overloads will let you choose options, e.g. allowing thousand separators.
Warning: TryParse() will always fail on an empty TextBox.

similar for reals (float, double), dates, etc.

everything in a TextBox is a string.

Smile | :)

Luc Pattyn

Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: how to make check of a value in a textbox is integer or string?

bounik22-Sep-09 14:17

bounik

22-Sep-09 14:17

thanks alot problem solved Smile | :)

Re: how to make check of a value in a textbox is integer or string?

jdhforever22-Sep-09 21:36

jdhforever

22-Sep-09 21:36

......nothing

Re: how to make check of a value in a textbox is integer or string?

PIEBALDconsult22-Sep-09 15:39

Serialization of objects IPHostEntry

22-Sep-09 15:39

Trust me, it's a string.

FJJCENTU22-Sep-09 12:55

FJJCENTU

22-Sep-09 12:55

I am tryng to serialize the IP's Server Addresses in my Lan using objects IPHostEntry for getting better the communications with them, later I need that the machines which are going to connect with such Server Serialize and Deserialize the Server's List, but when I try to serialize, both in binary or XML, I receive an error telling me that such object IPHostEntry is not marked as Serializable.

Any suggestion for avoiding this problem

Note: I Create a Dictionary<string, iphostentry=""> containing the name and IP data of every Server and such is the object which I want to Serialize, if the key and value are both strings there is no problem, but when I change to Type IPHOstEntry it does not work.

Regards

[Message Deleted]

Mark-12345678922-Sep-09 12:33

22-Sep-09 12:33

[Message Deleted]

PIEBALDconsult22-Sep-09 13:50

22-Sep-09 13:50

0) UPDATE INTO -- nope
1) colErrByUserID = '" + LoginForm.gb_strUserID + "' "; -- very bad idea

Mark-12345678922-Sep-09 14:35

22-Sep-09 14:35

Thanks for that! Sleepy | :zzz:

Very useful, not!

So what you are really saying is you don't know...

Poke tongue | ;-P

PIEBALDconsult22-Sep-09 14:37

22-Sep-09 14:37

No, I'm just not going to spoon-feed you. You'll find very few people here who will.

Mark-12345678922-Sep-09 16:07

22-Sep-09 16:07

Thats right you, keep telling yourself that!

Poke tongue | ;-P

PIEBALDconsult22-Sep-09 18:38

22-Sep-09 18:38

You'll see.

Repeat XML node

kurangu22-Sep-09 9:48

kurangu

22-Sep-09 9:48

I am having an XMl like below

<Details>
<det id=1 name="abc">
</Details>

Now i want to take the above xml as input and to repeat the node
like below using C#

<Details>
<det id=1 name="abc"/>
<det id=2 name="abc"/>
<det id=3 name="abc"/>
</Details>

Richard MacCutchan22-Sep-09 10:01

Richard MacCutchan

22-Sep-09 10:01

kurangu22-Sep-09 10:10

kurangu

22-Sep-09 10:10

Rich,

Just I want to repeat the node in aloop by incrementing id.

Richard MacCutchan22-Sep-09 10:14

Richard MacCutchan

22-Sep-09 10:14

I don't understand what your problem is. What code are you using to create the original XML, and what code have you tried to create the repeat items?

kurangu22-Sep-09 10:22

kurangu

22-Sep-09 10:22

Rich,

In c#.Original xml is a string which I get like below

<details>
<detail id="1" name="x"/>
</details>

I want to take that xml string and to repeat the nodes

foreach xml nodes

<details>
<detail id="1" name="x"/>
<detail id="2" name="x"/>
<detail id="3" name="x/>
</details>

id=2 and id=3 is repeated.want to do it in C#