Comments by Member 12285135 (Top 3 by date)

@kartik
datatype for in_time and out_time is time

i am facing the same problem. I am trying to import .CSV file using a webservice and wanted to display in GridView
My Web service code is:
[WebMethod]
public DataTable imoprtCSV(string path)

//for imortCSV it is giving error as (attenService1.imoprtCSV(string)':not all code paths return a value)


//code:

if(File.Exits(path))
{
StreamReader sr=new StreamReader(path);
string line =sr.ReadLine();
string[] value=sr.Spilt(',');
DataTable dt=new DataTable()
DataRow row;
foreach(string dc in values)
{
dt.columns.add(new DataColumn (dc))
}
while(!sr.EndOfStream)
{
value=sr.ReadLine.Split(',');
if(value.length==dt.Colunms.Count)
{
row=dt.NewRow;
row.ItemArray=value;
dt.Rows.add(row);
}
return dt;
}
}

//and while calling service i used
attenService1 ats=new attenService1();
//browse the csv file
string path=string.concat(Server.MapPath(~//aaa+FileUpload1.Filename);
FileUpload1.PostedFile.SaveAs(path)
GridView1.DataSource=ats.importCSV(path);
GridView1.DataBind();

please anyone solve my problem