|
Hello,
I have an sql server 2005 standart Edition and not express.A snapshot of my sqlexception is available at this link http://yfrog.com/iycaptureawj[^]
Thanks
|
|
|
|
|
Ah the joy of developing for mobile!
We can't read the full exception (your screen is too small).
Put a breakpoint at the exception statement, and examine the 'ex' variable when the expression occurs.
|
|
|
|
|
Hi Michel,
when running the exception is :
NULLREFERENCEEXCEPTION IS UNHANDLED
Null ReferenceException
and it point to this statement of my code:
dr.Close();
Thanks
|
|
|
|
|
No, that's another exception. It happens because your try block never executed succesfully.
put a breakpoint at MessageBox.Show(ex.Message);
and look at the value of ex then (with the debugger)
|
|
|
|
|
Hi Michel,
The same appears as i wrote last time,same exception expression
thanks
|
|
|
|
|
If I follow the code in the article he refers to, he would have dumped the instance browser, and locked SqlExpress to port 1433.
|
|
|
|
|
Try changing your connection string to
Data Source=192.168.1.4,1433;Network Library=DBMSSOCN;Initial Catalog=GMAO;User ID=sa;Password=sa
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hi Pete,
I changed but the sqlexception still:
Unknown connection option in connection string: network library.
thanks
|
|
|
|
|
Hi guys,
I depass the problem finally of the connection to the server due to the DATABASE FILE's ATTACHMENT.
Still now the problem in the filling of my combobox.In fact,no exception appears so connection to server works well.In other hand,nothing is added to my combobox.
I try to replace my sqldatareader by sqldataset but still the same thing:
private void Form6_Load(object sender, EventArgs e)
{
string sConnection = "Data Source=127.0.0.1,1433;Persist Security Info=True;Initial Catalog=GMAO;User ID=sa;Password=sa";
string sSQL = "SELECT com FROM energie; ";
SqlConnection conn = new SqlConnection(sConnection);
SqlCommand comm = new SqlCommand(sSQL, conn);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlDataReader dr = null;
try
{
comm.Connection.Open();
da.Fill(ds, "SQL Temp Table");
foreach(DataRow d in ds.Tables[0].Rows)
comboBox1.Items.Add(d.ToString());
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
return;
}
dr.Close();
comm.Connection.Close();
}
How do I depass that???
Thank u in all cases
I am really sooooooo happy
|
|
|
|
|
I want to fill in dictionary from table C#
thank you for your idea .
|
|
|
|
|
|
be more clear
EASY COME EASY GO
|
|
|
|
|
Then I expect you will wish to use this class[^].
It's time for a new signature.
|
|
|
|
|
I hate classes. They are boring.
|
|
|
|
|
You've posted the same question (badly) three times now. Would you please stop.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
|
hey,
I've two layers (logic and gui)
in gui i've some starting Form which rise a calculation (logic layer)
after the calculation is done, i want to retrieve the calculated data back to the gui layer (event handler) till this point everything is fine.
but what should i do in case and i want to retrieve the computed data to different form , from the one i started everything (starting Form) ?
the illustration of my question may be found here[^]
thanks in advance
|
|
|
|
|
You probably need to implement the Observer pattern.
Register all your forms that need updates to receive data change updates.
|
|
|
|
|
You mean to implement controller which control the whole application ?
|
|
|
|
|
There are many ways to achieve this.
One simple and effective way is to use/define class and create methods
which contains your logic.
Perform all your operations and store result in the class itself.
(using class member variables and methods)
And use the class object as navigator.
(You can pass class object from one form to
another using session, application object, etc...)
Hope this will help!
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
but how do i pass this kind of object ?
from logic layer back to gui layer i retrieved it by delegate event (extend EventArgs class), but the question is how do i pass it within the gui layer without accessing the updated controls in the other form...
i was thinking to implement some access methods (as a control setters) in the other form, and through them i'll update requested controls with the calculated data, but i'm not sure about this solution
|
|
|
|
|
|
hi all
i wanna have an xml creator (that will recive some Primitive data and & create a file & put it generated xml data)
is there any class to do this for me?
or i have to implement a class myself ?
any opinion or advice????
|
|
|
|
|
I don't think there is such think exists.
Better way is to use xml editor (best is XMLSpy) and then
incorporate your xml file in Visual Studio.
Hope this will help!
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
You probably need to use the XmlWriter[^] class.
It's time for a new signature.
|
|
|
|