Datetime strDate;
strDate="1/3/2012";
string strText="Ram,suresh";
string []strArr=strText.split(',')
for(i=0;strArr.Length;i++)
{
strSQl='insert into tablename(datet,textvalue) values ('"+strDate+"','"+ strArr[i].Tostring() +"');'
}
Please ignore the cases and use parameterized query.
updated, sorry for my mistake, thanks
Thanks