|
Dear all,
i made a windows application which has a datagridview control,
i filled these datagridview control 4 a table in SQL 2005 server,
i have a column on that table which have some unicode data, how can i convert these data to be able to fill it in its data.
Thanks alot
Hamody
|
|
|
|
|
Hi
I have a web-service which is created in VC++ 8, I only have the .wsdl file of that web-service along with some .dll files. For my local pc, i did access the web-service successfully by creating the virtual directory. But when i try to access that web-service from a different pc on the network, i can not access it. I get the connection time-out error, or the page can not be displayed error.
I also shared the folder in which web-service is residing but still this solution couldn't solve my problem.
Can anybody suggest any solution to access that web-service???
Regards
sAqIb
"Our scientific power has outrun our spiritual power. We have guided missiles and misguided men."
Dr. Martin Luther King Jr.
|
|
|
|
|
Hello
I want to verify a digital signature which is signed compatible with PPKCS#1 version 2(pss). As far as I have found in Microsoft .NET 2003 (.NET framework 1.1) there are only classes for version 1.5 and I haven't found anything about version 2 in that version. Am I right or not? Does .NET 2005 (.NET framework 2) support this one? If not, could you please help me with what I should do?
Thanks in advance.
|
|
|
|
|
How to pass a file name as command line argument in main function?
|
|
|
|
|
If you run your program from the console and type in the filename as in
myprog.exe myfile.xt
it will be passed in
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
i am NOT running it from console. i have to run it in windows mode. A sample code would help me better.Could u please?
|
|
|
|
|
There is no code to pass the filename, it has to be passed as a parameter. I think it's the same for windows apps. The string collection passed into your static void main contains the arguments. To pass it in, it needs to be an argument when the program is run.
Or do you mean something else ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
i am trying and hope i will get it soon. And will get back to u if i need...
|
|
|
|
|
Will this get value dashboardid from table into variable 'str'?
int str = "select dashboardid from dashboardlogin where userid=101";
cmd.CommandText = str;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.ExecuteNonQuery();
dashboardid is 'int' type in database.
but i have error in first line if i use the above code:
Cannot implicitly convert type 'string' to 'int'.
Do i need to add any other code also for getting its data into variable 'str'?
M new to c#,just learnt connecting database,a student doing project in c#.
plz reply
thank you.
nekshan.
|
|
|
|
|
I recommend giving up on windows forms and databases, and reading a beginners book on C#. Where did you find this code ? If you can't debug it, you're just going to have more and more trouble if you don't take my advice.
Nekshan wrote: int str
str is of type int.
Nekshan wrote: "select dashboardid from dashboardlogin where userid=101";
this is a string
Nekshan wrote: Cannot implicitly convert type 'string' to 'int'.
That is what the error is telling you.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
select dashboardid from dashboardlogin where userid=101;
Gives out a int value : dashboardid is int.
u mean i need to :
string str = "select dashboardid from dashboardlogin where userid=101";
Then convert the result to int?
thanx for the advice, i m already refering a book.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Nekshan wrote: u mean i need to :
string str = "select dashboardid from dashboardlogin where userid=101";
Yes, your query is a string
Nekshan wrote: Then convert the result to int?
Yes, you need to get an int back from the DB, you will need to convert this value.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
hi ...
you must change your code such as this :
int dashboardid = 10;
string str = "select " + dashboardid.ToString() + " from dashboardlogin where userid=101";
cmd.CommandText = str;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
-- modified at 0:36 Thursday 8th February, 2007
|
|
|
|
|
thank you.
int dashboardid = 10; ???
select query takes dashboardid from database...
|
|
|
|
|
you need to read a beginner book as well. This won't work, you're going to end up with select 10 from dashboardlogin where userid=101 10 is not a valid name for a column, and even if it was, this would not do what the OP wants
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
if you change select query like this , it work correctly
string str = "select [" + dashboardid.ToString() + "] from dashboardlogin where userid=101";
|
|
|
|
|
string str = "select [" + dashboardid.ToString() + "] from dashboardlogin where userid=101";
dashboardid.ToString() is giving error. after dashboardid. -> tostring option does not cum.
how can i convert a string type variable(having value int type) to integer?
can u plz help..
thank you
nekshan.
|
|
|
|
|
Nekshan wrote: dashboardid.ToString() is giving error. after dashboardid. -> tostring option does not cum.
His advice is totally wrong. Don't follow it.
Nekshan wrote: how can i convert a string type variable(having value int type) to integer?
string s = "10"
int n;
if (int.TryParse(s, out n))
{
// n now = 10
}
else
{
s was not a number
}
But, you won't get a single number out of the DB, you'll get a dataset, containing one data table, with a data row for each id that was returned.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
No, you are TOTALLY wrong. dashboardid is a column in his database. 10 is NOT a column in his database.
In fact, you don't need to call tostring when adding a number to a string, but in this case, your core advice is wrong.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
hi Graus,
i m trying this, but it does not seem to work out :
string s = cmd.CommandText = "select dashboardid from dashboardlogin where (loginname = 'nekshan') AND (loginpswd = 'engineer')";
cmd.CommandText = s;
cmd.CommandType = CommandType.Text;
int i = Convert.ToInt32(s); // giving error on this line
cmd.Connection = conn;
cmd.ExecuteNonQuery();
It gives error as : Input string was not in a correct format.
do i need to use dataset for it?
hope to get a reply.
thanx.
|
|
|
|
|
As Christian said before, you should definitely go out and buy you a book on C# and database programming.
Obviously, you still not get the idea that s is just a plain string that contains the text of your query, but the string itself cannot return the result of the query. That's what the classes inside the System.Data namespace are for. You already set up a SqlCommand instance in your code snippet, so why are you still trying to get the query result from the query string.? You should get the id by calling ExecuteScalar instead of ExecuteNonQuery on the SqlCommand instance and cast it to int. Take a look at the MSDN topic of the ExecuteScalar method; it contains an example that is similar to what you're trying to achieve.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
You are totally, utterly lost. If you can't understand what I've explained to you, that proves you're in over your depth. Work through a beginners book then come back to this stuff.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
SqlConnection conn=new SqlConnection("server=(local);Initial Catalog=Northwind;user id=istore;pwd=istore");
conn.Open();
SqlCommand cmd=new SqlCommand("select employeeid from employees where employeeid=1",conn);
Label1.Text=Convert.ToString(cmd.ExecuteScalar());
-------------
this code surely works
try it!!;P
|
|
|
|
|
SqlCommand cmd=new SqlCommand("select employeeid from employees where employeeid=1",conn);
Label1.Text=Convert.ToString(cmd.ExecuteScalar());
employeeid is an int in db.
answer is coming in label, but if i put a variable like dis :
int s = Convert.ToString(cm.ExecuteScalar());it gives error : Cannot implicitly convert type 'string' to 'int'.
if i put variable like:
string s = Convert.ToString(cm.ExecuteScalar());
it gives error : Cannot convert from 'string' to 'int', in the below function.
as i have to display dis employeeid ie 's' in a function:
funEntrylogin(s, tb_id.Text, tb_pswd.Text, DateTime.Now, DateTime.Now);
|
|
|
|
|
Hi!
I have to implement CSS in my C# asp.net web application.
I made a Css class and used it in my aspx form. But formatting is applied only on backgroud of the form. formatting on the web controls like buttons and labels is not applied. Can anyone guide me to solve this problem.
Thanx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
