amie hossein
28-06-2012, 19:53
سلام یه فرم تو .net 2010 درست کردم که می خوام وقتی فرم لود میشه کنترل دیتا گرید رو پر کنه ولی همش خطا می زنه و اجرا نمیشه.لطفا کمک کنید.
using system.data.sqlclient;
Public Class Form1
Public void fill()
{
sqlconnection objconnection = new sqlconnection("data source=localhost;initial catalog=database1;integrated security=true");
sqldataadapter objdataadapter= new sqldataadapter("select * from tbl1",objconnection);
dataset objdataset= new dataset();
objconnection.open();
objdataadapter.fill(objdataset,"tbl1");
objconnection.close();
dgv.autogeneratecolums=true;
dgv.datasource=objdataset;
dgv.datamember="tbl1";
objdataadapter=null;
objconnection=null;
}
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Fill();
End Sub
End Class
مثلا این خطاها رو می ده:
Error 1 Statement cannot appear outside of a method body/multiline lambda. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 2 1 WindowsApplication1
Error 2 End of statement expected. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 5 17 WindowsApplication1
Error 4 Declaration expected. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 8 1 WindowsApplication1
Error 16 'Fill' is not declared. It may be inaccessible due to its protection level. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 25 5 WindowsApplication1
using system.data.sqlclient;
Public Class Form1
Public void fill()
{
sqlconnection objconnection = new sqlconnection("data source=localhost;initial catalog=database1;integrated security=true");
sqldataadapter objdataadapter= new sqldataadapter("select * from tbl1",objconnection);
dataset objdataset= new dataset();
objconnection.open();
objdataadapter.fill(objdataset,"tbl1");
objconnection.close();
dgv.autogeneratecolums=true;
dgv.datasource=objdataset;
dgv.datamember="tbl1";
objdataadapter=null;
objconnection=null;
}
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Fill();
End Sub
End Class
مثلا این خطاها رو می ده:
Error 1 Statement cannot appear outside of a method body/multiline lambda. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 2 1 WindowsApplication1
Error 2 End of statement expected. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 5 17 WindowsApplication1
Error 4 Declaration expected. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 8 1 WindowsApplication1
Error 16 'Fill' is not declared. It may be inaccessible due to its protection level. d:\documents and settings\barati\my documents\visual studio 2010\Projects\WindowsApplication1\WindowsApplicati on1\Form1.vb 25 5 WindowsApplication1