|
Hello,
I have a C# project with a Microsoft Access Database and a Crystal Reports file. I've put the database in the Debug directory, so that after creating the setup, the program finds the database in the curent directory. The problem is with the report file. So, after creating and installing the setup, the report loads, but the fields from the report are empty (the fields are the database columns). So my guess is that after the setup, the report file doesn't find the database anymore. where can i change the path to the database (but not in the report wizard, somewhere in the code). Or maybe someone had already this problem and knows the solution.
Thanks in advance!
|
|
|
|
|
Hi
I having an application which is using the AXWebBrowser component, It is working fine in my machine (server). While i am trying to access the same page from the remote machine it dosent say any error but it displays nothing, can any one guide me what's the problem is.
Thanks
Warm Regards
Prakash-B
|
|
|
|
|
Hello 
I have two datasets one is filled from database (dataset1) and another is filled from the file (dataset2). I want to compare rows in those datasets and do this:
1. if row is present in dataset2 then insert it into dataset1
2. if row is present in both (dataset2 and dataset1) then update dataset1
how can I do this easily? is there function for comparing two datasets which returns some kind of diff dataset?
thanks to any help
Peter
|
|
|
|
|
I have to code a program so that I after entered an URL of the web-service, if it's correct, methods that that web-service supplies will appear with parameters they require, and then I can invoke a method.
I remember that there is an article focus on my problem but I can not find it.
Anyone help me with that!?
|
|
|
|
|
All you have to do is visit the URL of the webservice (ie localhost/WebServices/WebService.asmx) and you'll see a list of available methods for that web service. Then if you follow a link to one of the methods, you'll see a description of the web service.
|
|
|
|
|
The browser does it for you, what I want is my own application, which has the same functionality as the browser
|
|
|
|
|
hi,
i'm using Component One TrueDBGrid in my form.
one of the columns is the "Amount" field. ItShould allow users to enter only integers or float type. But if he attempts to enter characters, error provider should be shown..this will be done in RowColChange event of the grid...so he shuld not be able to enter any characters or special characters..
Please tell me how i'll do this...i tried using the EditMask property of the grid i.e.
tdbgridOnewayReturn.Splits[0].DisplayColumn[3].DataColumn.EditMask = "0000000.00";
but this doesn't take decimal..if i enter 0000332.99, then it saves as 3329900..which is not correct.
But if i use NumberFormat property of the grid :
tdbgridOnewayReturn.Splits[0].DisplayColumns[3].DataColumn.NumberFormat = "Fixed";
then,the user can also enter characters..which is not correct..
please do tell me how i'll resolve this problem....
thanx ..
|
|
|
|
|
Hello,
I have just started to use C#, I have to make a User Preferences Dialog box like the 'Options' dialog in the VS.NET IDE, I have been searching online but (may be I am using wrong keywords for it) have not found any tutorials...
second problem is that I have a form that has two parts, 1. Main Part, 2. Sub Part, and I want the sub-part to appear only if the check box 'Show Sub Part' is checked, otherwise it should remain hidden...
Any help would be much appreciated (I'd be grateful if it's a link to some tutorial that deals with something like this)
Peace...
- A programmer's national anthem; "AAAAAHHHHH!!!!"
|
|
|
|
|
signbit wrote: have not found any tutorials...
Those sort of UI components do not exist in VS, they are custom written. So, you'll need to find a component that does it, not a tutorial showing you how to do it.
signbit wrote: second problem is that I have a form that has two parts, 1. Main Part, 2. Sub Part, and I want the sub-part to appear only if the check box 'Show Sub Part' is checked, otherwise it should remain hidden...
Put a control on the edge of the area you want to hide, and use the Width property of your form to show/hide it based on the position of this control. A panel or something, maybe a label with no text ? It's a place holder. Then you need to also make your form a fixed size so the user does not maximise it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
|
You can create child forms and show them as modeless dialogs, and then you can set their visible propertly.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
hmm, that sure helps...
and hey!, instead of writing a new control for the first problem, why can't I use the same approach i.e. making several penals and show/hide appro
Thanks...
- A programmer's national anthem; "AAAAAHHHHH!!!!"
|
|
|
|
|
Yes, a tree on the right and a lot of panels that you show and hide would work just fine. I'd just be inclined to wrap that in a control, and then create the panels as user controls, if it was me.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Ummm... Okay... I'll put that in a control
Thanks for your help, it was great...
- A programmer's national anthem; "AAAAAHHHHH!!!!"
|
|
|
|
|
I want to save a graphic that was created in a c# program that I wrote to an ico. I tried:
pictureBox1.Image.Save(sfd.FileName,ImageFormat.Icon);
but it saved a file that was an invalid ico file. Can anybody help me out?
JGA
|
|
|
|
|
See a recently posted article on how to handle this. Sorry no link, but it should be under recent still.
xacc-ide 0.0.99-preview7 now with C#, C, C++, IL, XML, Nemerle, IronPython, Perl, Caml, SML, Ruby, Flex, Yacc, Java, Javascript, Lua, Prolog and Boo highlighting support!
|
|
|
|
|
ok.. i have a function and it looks like this..
public static void test(ListBox lst,string tablename)
{
string myConn = "Server=(local);Integrated security=SSPI;database=halkdanis";
string str = "SELECT * FROM '"+tablename+"'";
SqlDataAdapter dataAdapter = new SqlDataAdapter(str,myConn);
DataSet dt = new DataSet();
DataAdapter.Fill(dt,tablename); // here it says error
DataTable dtb = dt.Tables[0];
foreach(DataRow dtr in dtb.Rows)
{
lst.Items.Add(dtr["username"]);
}
}
as u can see, i want to get data from mssql, and put the usernames in a listbox and i want to use this function several times depends on tablenames but it gives error at:
DataAdapter.Fill(dt,tablename) ;
i guess its coz of `"` char or dunno what is it..
any help would be great..
thx.
good coding..
god is a coder..
|
|
|
|
|
Don't enclose the table name in single quotes.
Better yet, use parameters:
string str = "Select * from @table";<br />
SqlDataAdapter dataAdapter = new SqlDataAdapter(str,myConn);<br />
dataAdapter.SelectCommand.Parameters.Add("@table", tablename);<br />
DataSet dt = new DataSet();<br />
dataAdapter.SelectCommand.Connection.Open();
DataAdapter.Fill(dt,tablename);
...<br />
Since you are just copying one colum value to a listbox, theis would be much more effieciently done with an SqlDataReader, and the select commnd should only ask for the one column:
string str = "Select [username] from @table";<br />
SqlConnection myConn + new SqlConnection("Server=(local);Integrated security=SSPI;database=halkdanis");<br />
SqlCommand cmd = new SqlCommand(str,myConn);<br />
cmd.Parameters.Add("@table",tablename);<br />
myConn.Open();<br />
SqlDataReader reader = cmd.ExecuteReader();<br />
try<br />
{<br />
while(reader.Read()) <br />
{<br />
lst.Add(reader.GetString(0));
}<br />
}<br />
finally<br />
{<br />
reader.Close();
myConn.Close();
}
This is much faster, and consumes much less working memory. It also transfers much less data 'over the wire' if the server is on a different box.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
this is still not working...
string str = "Select [username] from @table";
SqlConnection myConn = new SqlConnection("Server=(local);Integrated security=SSPI;database=halkdanis");
SqlCommand cmd = new SqlCommand(str,myConn);
cmd.Parameters.Add("@table",tablename);
myConn.Open();
SqlDataReader reader = cmd.ExecuteReader(); // here it sais error
try
{
while(reader.Read())
{
lst.Items.Add(reader.GetString(0)); //since we only asked for one colume, just get string from col 0
}
}
finally
{
reader.Close();//close reader
myConn.Close();//close connection
}
and i also tried myStyle with parameters..
string str = "Select * from @table";
SqlDataAdapter dataAdapter = new SqlDataAdapter(str,myConn);
dataAdapter.SelectCommand.Parameters.Add("@table", tablename);
gives the same error
DataAdapter.Fill(dt,tablename); // error here..
|
|
|
|
|
What is the error? What are you passing in for tablename? Does the table exist?
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
-- modified at 22:45 Sunday 30th October, 2005
|
|
|
|
|
public static void test(ListBox lst, string tablename)
{
string str = "Select [username] from @table";
SqlConnection myConn = new SqlConnection("Server=(local);Integrated security=SSPI;database=halkdanis");
SqlCommand cmd = new SqlCommand(str,myConn);
cmd.Parameters.Add("@table",tablename);
myConn.Open();
SqlDataReader reader = cmd.ExecuteReader(); // error points here
try
{
while(reader.Read())
{
lst.Items.Add(reader.GetString(0)); //since we only asked for one colume, just get string from col 0
}
}
finally
{
reader.Close();//close reader
myConn.Close();//close connection
}
}
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
and i coulnt take take SqlDataReader reader = cmd.ExecuteReader(); in a try - catch block coz it gives `reader` couldnt find errors ..
my usage of the function is..
defaultCheck.test(empList,"employeeinfo"); // empList = listBox , "employeeinfo" = tablename
thx.
|
|
|
|
|
Are you sure your Sql Server is running? "system error' sounds rather bad, like something fundamental is wrong. Can you open the table in Enterprise Manager?
I don't understnd your comment about not being able to move the executereader() call into the try block --- are you saying that
public static void test(ListBox lst, string tablename)<br />
{<br />
string str = "Select [username] from @table";<br />
SqlConnection myConn = new SqlConnection("Server=(local);Integrated security=SSPI;database=halkdanis");<br />
SqlCommand cmd = new SqlCommand(str,myConn);<br />
cmd.Parameters.Add("@table",tablename);<br />
myConn.Open();<br />
<br />
try<br />
{<br />
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read()) <br />
{<br />
lst.Items.Add(reader.GetString(0));
}<br />
}<br />
catch(SqlException e)<br />
{<br />
System.Diagnostics.Trace.WriteLine(e.message);<br />
}<br />
finally<br />
{<br />
reader.Close();
myConn.Close();
}<br />
<br />
}
Doesn't throw an error?
Also, I'm more accustomed to seeing "Initial Catalog=halkdanis;" in an Sql Server connection string, rather than "database=" "database" might work, but then again it might not..
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
my mssql server and everything seems fine, this is just a function of the system, i can add, delete, update records on my program right now and there is no problem, what i wanted to do is, i'm using this code 5 times in the program but each time i have to specify the tablename , so i had to use 5 functions only the tablenames are different. and instead of doing like that i wanted to use only one function and take the tablename as a string so i could use it..
try
{
SqlDataReader reader = cmd.ExecuteReader(); // error points here
while(reader.Read())
...
when i do like this , it gives error like where the heck is the reader but
SqlDataReader reader = cmd.ExecuteReader(); // error points here
try
{
while(reader.Read())
...
no errors but when i wanted to use the function it gives sql error and points
SqlDataReader reader = cmd.ExecuteReader();
thanks for your help but i guess i have to use 5 function grrr
|
|
|
|
|
Try it more youre original way. Instaed of a parameter, build up the SQL string like this:
string str = "select [username] from [" + tablename + "]";
leave the rest of the code the same (just remove the add parameters part).
the square brackets around username are important, since "username" is a keyword. Your original version had single quotes around tablename, which was definitely a problem. The square brackets should work.
To fix the compile error with the reader inside the try block,
SqlDatareader reader = null;<br />
try<br />
{<br />
reader = cmd.ExeuteReader();<br />
...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
-- modified at 23:22 Sunday 30th October, 2005
|
|
|
|
|
awesome !!! thank you so much.. it works ! 
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
