Comments by fatima...68 (Top 23 by date)

yes i did this
i delete old image and insert the new image
this is my insert code
pic_count = Directory.GetFiles("c:\\OMEGA\\kaj" , "*.Bmp", SearchOption.AllDirectories).Length;
string[] fileInDir = new string [pic_count];
string[] NAM = new string[pic_count];

fileInDir = Directory.GetFiles("c:\\OMEGA\\kaj", "*.Bmp", SearchOption.TopDirectoryOnly);

int l = fileInDir.ToString().Length;
int index = 0;

for (int i = 0; i < pic_count; i++)
{
index = fileInDir[i].ToString().LastIndexOf("\\");
if (index > -1)
{
NAM[i] = fileInDir[i].ToString().Substring(index + 1);
}

IMG = Image.FromFile("c:\\OMEGA\\kaj\\" + NAM[i] + "");
byte[] data;
using (MemoryStream ms = new MemoryStream())
{
IMG.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
data = ms.ToArray();
}
picBoxUser.Image = IMG;

string num = "select SERIAL from _TRBS_PIC where SERIAL = '"+int.Parse(NAM[i].Replace(".Bmp",""))+"' ";

SqlDataAdapter dp = new SqlDataAdapter (num , sqlCnn);
DataTable tp = new DataTable ();
dp.Fill(tp);

if (tp.Rows.Count>0)
{
p_num = int.Parse(tp.Rows[0][0].ToString());
}


if (tp.Rows.Count <= 0)
{
try
{
double max;
DateTime d;
SqlCommand cmdDateTime = new SqlCommand("Select getdate() ", sqlCnn);
sqlCnn.Open();
d = DateTime.Parse(cmdDateTime.ExecuteScalar().ToString());
sqlCnn.Close();
SqlCommand cmdCount = new SqlCommand("Select Count(_ID) from _TRBS_PIC ", sqlCnn);
sqlCnn.Open();
double No = double.Parse(cmdCount.ExecuteScalar().ToString());
sqlCnn.Close();
if (No == 0) max = 1000 + StID;
else
{
SqlCommand cmdMax = new SqlCommand("Select max(_ID) from _TRBS_PIC ", sqlCnn);
sqlCnn.Open();
max = double.Parse(cmdMax.ExecuteScalar().ToString());
max = max % 1000;
max = double.Parse(cmdMax.ExecuteScalar().ToString()) - max + 1000 + StID;
sqlCnn.Close();
}
ID = max;
string strsql = "INSERT INTO _TRBS_PIC ([_ID]"
+ ",[SERIAL]"
+ ",[DATE]"
+ ",[PIC]"
+ ",[NUM]"
+ ",[DETAIL]"
+ ",[ESERIAL]"
+ ",[UID1]"
+ ",[UID2]"
+ ", [_LastSecurityOption], [_LastSaveOption], [_LastDate], [_LastTime], [_LastDateTime], [_LastUID], [_LastStID], [_LastStatus]) values ('"
+ max.ToString()
+ "','" + NAM[i].Replace(".Bmp","")
+ "','" + fieldTxt2.Text
+ "','" + picBoxUser.Image
+ "','" + pic_count
+ "',' "
+ "','0"
+ "','" + UID1.ToString()
+ "','" + UID2.ToString()
+ "','0','0','" + d.ToShortDateString().ToString() + "','" + d.ToShortTimeString().ToString() + "','" + d.ToString() + "','" + UID.ToString() +

thanks my firiend
what do you mean

thanks i did it and i fix my insert command but i have that error yet

please explain more about it
thanks'

hi my friend its easy for text box but i want it for data grid view there is no event for that

hi my friend i want to convert a number like 4561230 to 4,561,230 as when user typing. its mean in one column of data grid view when user type the forth number last three number automatically separate from right whit ","
is it clear?

my DB is sqlserver and solution is windows app of c# my friend

thanks my friend

between number and word is one space

thanks ok
like this:
1000 time
2000 min
2000 second
3000 day
4000 week

thanks my FRIENDS

thanks my friend i do it and if i had a problem i will need your help

hi my friend for example i want when im typing 15646 its outomaticaly convert to 15,646

hi thanks yes i want it
but in grid view
i cant solve it

smallest and biggest number through inputting numbers

it is a very simple example but i dont know that how i can put numbers from text box in array

thanks for your comment

from one text box dear friend