Comments by Kamalkant(kk) (Top 41 by date)

SqlCommand cmd2 = new SqlCommand("select role from users where EmailAddress=@str", conn);
cmd.Parameters.Add(new SqlParameter("@str", str));
SqlDataReader dr2 = cmd2.ExecuteReader();


In The place of str u just pass the EmailAddress as input variable.

Url be the http://~ address

go to my solution and check the 5 stars on right side of Solution line

thanks ,So give the vote/rating plz

thanks, Sunil for your voting

yes ......

No, I want a message like "Success" after some worked is overed in .aspx page .Then I call the webpage .aspx page in my windows application page for getting the value form .aspx page.

Hi sushil I am not clear for your ansswer .So plz elaborate.

using System.Collections;

go through google

you can store listbox1 value in to another variable and the pass it in to the query

object strval=listBox1.SelectedValue;
command.CommandText = "SELECT * FROM results WHERE Courseno = " +strval ;

In palce of TableName write your table name

Which version of sql server have u used?

select * from table where id !=(select top 1 id from table)

Thanks to all

problem in foreach loop ,when reading

Hi Sebastian, I am adding message into my dictionary as well as to list of Global class "GlobalVariables " ,When I am reading from them and shown into my text by using setTextBoxValue() method it will shown the above error.

or u can set the identity property for that column like :
create table emp
(column1 varchar(20),
column2 int identity(1,1))
in table creation time

no yaar

Thanks Amit, but I need in SQL SERVER

This namespace is not working in my form2 code page.

DispatcherTimer belong to which Namespace?

When I first time execute code , my thread is working fine and shown the message but I want any solution that the thread will again fired after some time interval.So that my process is continue. Is there any property or option in thread to start after some time interval or How to start thread with timer control?

I found that code to print the pdf file.Is there any mistake in my code plz help

YOUR TABLE IS ONE I.E PC

Hi Nelson Still I am not getting correct answer from any body.Can u plz give your Email_ID of gmail or any Contact Num.
My Email_ID is:kamalakanta.nayak09@gmail.com

Hi,ANIL you just changed Connection string of that Datasource1 but i am not saying to create new datasource1.

Showing error as follows;

Input string was not in a correct format.Couldn't store <> in quantity Column. Expected type is Int32.

my datavalue is integer type no need to convert it into string type

Type of conditional expression cannot be determined because there is no implicit conversion between 'System.DBNull' and 'int'

You have first know the url ,then download

I think problem in lblID.Text value.

exec sp_configure 'show advanced options', 1
RECONFIGURE;
exec sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE;


SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Users\Admin\Desktop\247ProjectMonitoring\UploadExcelfile\Test.xls;HDR=YES;IMEX=1;', 'SELECT * FROM [Sheet1$]')
--------------------------------------------
STILL THE ERROR IS COMMING
i.e:The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

exec sp_configure 'show advanced options', 1
RECONFIGURE;
exec sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE;


SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Users\Admin\Desktop\247ProjectMonitoring\UploadExcelfile\Test.xls;HDR=YES;IMEX=1;', 'SELECT * FROM [Sheet1$]')
--------------------------------------------
STILL THE ERROR IS COMMING
I.E:The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".