ASP.NET

nothingbutcat wrote:

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Naveed Kamboh wrote:

sql="select * from tbl where fieldname=" + dropdownlist.selectedvalue;

HttpPostedFile filupload = FileUpload1.PostedFile;<br />
        int filelength = System.Convert.ToInt32(filupload.ContentLength);<br />
        byte[] data = new byte[filelength];<br />
        string name = FileUpload1.FileName.Remove(3);<br />
        filupload.InputStream.Read(data, 0, filelength);<br />
        string username = this.Session["username"].ToString();<br />
        //string getdir = Directory.GetCurrentDirectory();<br />
        string filename="C:\\Inetpub\\wwwroot\\website1\\data\\"+username+".xls";<br />
        filupload.SaveAs(filename);<br />

string conn = @" Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Inetpub\wwwroot\website1\data\"+ sheetname+";Extended Properties=Excel 8.0;Persist Security Info=false";<br />
                string sqlconn = "Data Source=CHITRA;Initial Catalog=northwind;Integrated Security=True";<br />
        OleDbConnection xlcon = new OleDbConnection(conn);<br />
         string strComand = "select * from [sheet1$A1:C3]";<br />
        OleDbDataAdapter xlda = new OleDbDataAdapter(strComand, xlcon);<br />
        DataTable xldt = new DataTable();<br />
        DataSet xlds = new DataSet();<br />
        <br />
        xlda.Fill(xldt);<br />
        xlda.Dispose();<br />
        SqlConnection sqlcon = new SqlConnection(sqlconn);<br />
        SqlDataAdapter sqlda = new SqlDataAdapter("select * from products", sqlcon);<br />
        <br />
        DataSet ds = new DataSet();<br />
        sqlcon.Open();<br />
        sqlda.Fill(ds, "products");<br />
        <br />
        foreach (DataRow xlrow in xldt.Rows)<br />
        {<br />
            DataRow ordr = ds.Tables["products"].NewRow();<br />
            string productid, productname, unitprice;<br />
            ordr["productid"] = xlrow[0];<br />
            ordr["productname"] = xlrow[1];<br />
            ordr["unitprice"] = xlrow[2];<br />
            //productid = xlrow[0].ToString();<br />
            //productname = xlrow[1].ToString();<br />
            //unitprice = xlrow[2].ToString();<br />
            //SqlCommand cmd=new SqlCommand("insert into products (productid,productname,unitprice)values('"+productid+"','"+productname+"','"+unitprice+"')");<br />
            //cmd.Connection = sqlcon;<br />
            //cmd.ExecuteNonQuery();<br />
            ds.Tables["products"].Rows.Add(ordr);<br />
            sqlda.Update(ds, "products");<br />
        }<br />
        <br />
        //orda.Update(ds, "products");<br />
        ds.AcceptChanges();<br />
        sqlda.Dispose();