|
|
|
Hi everybody!
I have an Excel file and i want to select from the file just some rows.
I can select the whole file in the following way:
private static DataTable GetDataFromXLS(string strFilePath)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+strFilePath+"; Jet OLEDB:Engine Type=5;" + "Extended Properties=Excel 8.0;";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
DataTable dt = myDataSet.Tables[0];
return dt;
}
But i don't need the whole excel file just a few rows. How can i do this from the query?
It is possibile to do this with a query?
Thanks for your help!
|
|
|
|
|
Hi
I have to text box txtbox1 is for name and txtbox2 for contact number.
when i enter name only the character keys are enabled.
Also when i enter contact number only the key from 0 to 9 is enabled.
how do i write code.
its ery urgent.
|
|
|
|
|
dnyanubhamare wrote: its ery urgent.
It's amazing how many people have' very urgent' questions, but can't be bothered typing them in to google.
Handle the KeyPressed event. The Char class has static methods like IsChar and IsControl, use these to work out if you set the HAndled property on the eventargs to true, to reject the keypress. Don't forget IsControl, or arrows, delete, etc won't work in your textbox.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Guy
very easy man
when you press key , just check ur keypressEventArhs e value.
e.keycode==47----->57
same like other character ascii value also.
there a lot of example in google.
thanks
|
|
|
|
|
for only numbers
if(!char.IsNumber(e.KeyChar) & !char.IsControl(e.KeyChar))
e.Handled = true;
for only chars
if(!char.IsLetter(e.KeyChar) & !char.IsControl(e.KeyChar))
e.Handled = true;
hope it will help
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
But you should also always check Char.IsControl, otherwise keys like delete will not work.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
thanks, i forgot
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
NEVER EVER do this. The Char.IsDigit, etc methods are there for a reason.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Ravenet wrote: very easy man
when you press key , just check ur keypressEventArhs e value.
e.keycode==47----->57
same like other character ascii value also.
Please don't do this as this is really bad practice - you're limiting yourself to targeting ASCII here, plus you have to take care of both Upper and Lower case characters. .NET provides things like Char.IsLetter for a reason.
|
|
|
|
|
OK thanks Pete O'Hanlon
but bascially i gave idea to that guy.
|
|
|
|
|
Yup, it was an idea - the wrong idea, and taught him bad practice to boot.
kudos.
|
|
|
|
|
hey man
that not wrong idea ok, but Peter said better than my idea.
DONT SAY WRONG.
thanks
|
|
|
|
|
<asp:imagebutton id="ImageButton1" runat="server" imageurl="<%# Eval(" filename=")">' PostBackUrl='<%# Eval("no" , "~/Tracts.aspx?no={0}") %>' />
how to get no.if u know code replay to me..
|
|
|
|
|
Hard to make sense of what you're after here. Do you mean how do you format the string ? string.Format(" "~/Tracts.aspx?no={0}", Eval("no")) seems like a likely candidate.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
i do ur code in pageload event but above error is occure.any code..
|
|
|
|
|
Correct. So, if he's not using a databound control, and placing an image inside it, then the question would be kind of pointless, I expect.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
<columns> <asp:templatefield>
<itemtemplate>
<asp:imagebutton id="Image1" runat="server" imageurl="">]]>' CommandArgument='<%# Eval("no")%>' PostBackUrl='<%# Eval("no" , "~/Default2.aspx?no={0}=") %>' Width="150px"/>
]]>
<itemtemplate>
i set Databinder inside imageButton but how to get no in Default2.aspx page.
h = string.Format("~/Default2.aspx?no={0}", Eval("no"));
where it is write Default.aspx or Default2.aspx.
|
|
|
|
|
putting it on the URL is going to do it. Perhaps if you could explain exactly what the issue is here, are you not getting the right URL ?
sugunavathy wrote: where it is write Default.aspx or Default2.aspx.
Well, default2.aspx would be a bit late, wouldn't it ? I am saying that if what you're saying is that your Eval statement does not work, doing a string.Format in it's place should work, IMO. But, again, I am guessing, because you're not really telling us what is going wrong.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi very thanks to replay to me.
<asp:imagebutton id="ImageButton1" runat="server" imageurl="<%# Eval(" filename=")">' PostBackUrl='<%# Eval("no" , "~/Tracts.aspx?no={0}") %>' />
this code is default.aspx page coding.
this page is transfer to Tracts.aspx page.but how to get no in Tracts.aspx page.
|
|
|
|
|
Does somebody know how to block the execting of sql server .Problem is if somebody authenticates window password , then it becomes very easy for someone to make ammendments in the database .
Or somebody may be having any registry tips to edit the registry for sql server 2000 exe to block it's executing.
I meant when i click the sql server 2000 tab in the program files , i should get the message , the administrator has blocked the program to execute.
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
I seriously doubt this has anything to do with C#. In the first place, my mind boggles as to why somebody would want to do this.
Sonia Gupta wrote: Problem is if somebody authenticates window password , then it becomes very easy for someone to make ammendments in the database .
That's what the password is there for. 
You could try restricting folder rights, I suppose....
Cheers,
Vikram.
"The weak can never forgive. Forgiveness is the attribute of the strong." - Mahatma Gandhi.
|
|
|
|
|
So, set up your database on a machine that general users do not have access to, and don't used mixed mode authentication.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
sql dont have securities, anyone, who have knowledge about sql can do changes in databases.
i have already tried to set password on my database, but there wasnt anything like this, we can just make users then assign passwords but if someone uses Windows Authentcation then that person can do whatever wants
Becoming Programmer...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
