|
Hi All,
How to update a cell value in a excel sheet.
Ex. Need to update A1 value in excelworksheet using oledb.
When tried to update I am getting error like
"No value given for one or more required parameters."
Raghu
|
|
|
|
|
Hi,
I just found the solution. May be this could help others.
Dim sConn As String
Dim OleConn As OleDbConnection
Dim OleCmd As OleDbCommand
sConn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\testexcel.xls;Extended Properties=""Excel 8.0;HDR=No;"""
OleConn = New OleDbConnection(strConn)
OleConn.Open()
OleCmd = OleConn.CreateCommand()
Olecmd.commandtext="UPDATE [sheet1$F1:A1] SET F1 ='6'"
OleCmd.ExecuteNonQuery()
OleCmd = Nothing
OleConn.Close()
On giving the above statement, the cell A1(first row first column) gets updated with value in the excel.
Regards,
Raghu.
|
|
|
|
|
I want to upload image, for that I'm using FileUpload control.
But i want to change look n feel of Browse button.
Also I don't want its text as "Browse...", I want its text as "Choose File".
I don't want TextBox which we get along with the Browse Button.
Can I put Imagae on that?
Pls help. Thank You.
|
|
|
|
|
You can't do anything to the browse button. You can't change it. You can't use the click() method on it in order to hide it and trigger it from another control.
You could try to place an element on top of the button and make it transparent to clicks so that the click ends up on the original button. The upload field looks a bit different in different browsers, though. You should prepare yourself for a lot of tweaking and testing in a wide range of browsers.
Also, after deploying this you should test it with every new version of every browser to make sure that it still works...
---
b { font-weight: normal; }
|
|
|
|
|
Thank You for replying.
Can you pls tell me which elements I can use for that?
How to make element transparent to clicks?
Thanking You In Advance.
|
|
|
|
|
hello
can i create an array of dataset ?
|
|
|
|
|
u can use Hashtable to store array of datasets e.g
HashTable ds_array = new HashTable();
ds_array.Add(1,dataset1);
ds_array.Add(2,dataset2);
ds_array.Add(3,dataset3);
ds_array.Add(4,dataset4);
.
.
.
.
.
so on
rahul
|
|
|
|
|
Hi all! I want to show description of the property(of a user control) in the property dialog box in Visual Studio. I tried to use following code Text1 property is showing in the property box but but default value and its description are not there. Any idea to how to fix it?
Bindable(True), DefaultValue("Nitin"), Description("Text value of the text box"), Category("Misc"), Browsable(True) _
'Above line was not showing properly here so I remove < at the start & > at end
Public Property Text1() As String
Get
Return TextBox1.Text
End Get
Set(ByVal value As String)
TextBox1.Text = value
End Set
End Property
Thanks
|
|
|
|
|
There is an attribute DisplayName you can use it to customize the text displayed in the property grid.
Have fun!
|
|
|
|
|
Hi all
Iam trying to open a new window
In general we open like
a href="#" onclick="javascript:window.open('File.html',null,'height=500, width=860,status= yes,resizable= no,scrollbars=no,align=center, border=0,toolbar=no,location=no,menubar=no,top=0,left=0')"
* * Popup Window * *
It open " File.html "
It is in case clicking of any control in First page
But i want to open directly the " File.html " with some width,hight
Can any one tell me how can i do this
THX
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
Hi,
You want to open the windown on page load?? or ???? automatically menas?? If you want to open the window on page load means then:
<body "onload"="javascript:window.open('File.html',null,'height=500, width=860,status= yes,resizable= no,scrollbars=no,align=center, border=0,toolbar=no,location=no,menubar=no,top=0,left=0')">
Regards
Know is Drop, Unknown is Ocean
|
|
|
|
|
HI thx for reply
I want to open only one window which has some 'height=500, width=860,status= yes,resizable=no etc...
EX :
--
When we type A address in browser -- http://www.some.com/file.html
Then automatically the window height=500, width=860,status=
yes,resizable=no etc...
Then we have only 1 window
THX
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
a href="#" onclick="javascript:window.open('File.html',null,'height=500, width=860,status= yes,resizable= no,scrollbars=no,align=center, border=0,toolbar=no,location=no,menubar=no,top=0,left=0')"
karthik.
|
|
|
|
|
Hi
When i use this it is asking the confirm box
'Do you want to close the window'
With out asking the confirm box how can i close the window
body onload="javascript:window.open('File.html',null,'height=500, width=860,status= yes,resizable= no,scrollbars=no,align=center, border=0,toolbar=no,location=no,menubar=no,top=0,left=0'); self.close();">
THX
asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf
|
|
|
|
|
Hi,
When you open a window with javascript It will not display confirm box. It will only display confirm box when window is opened directly or is opened by some other method like Response.Redirect method of Asp.NET.
Well as far as I know there is no soloution of the situation.
Iftikhar Ahmed Khan
Researcher,
School of Information systems and Computing Brunel
|
|
|
|
|
hello,
can anybody explain what visual studio.net actually doing while loading a solution and displaying message "Merging web server state..." in status bar ?
|
|
|
|
|
HI
Guys, if i have saved the uploaded file to the private folder on the server, not under the folder in my application directory, then how to access it, Can any one let me know abt it, plzzz reply ASAP, thankx
|
|
|
|
|
Hi
Guys, i need help,Can any one let me know that how to make the uploaded files secure, so that the user could not access the file by copying the url and then pasring it in browser to access that uploaded file, When Viewing that file, there should be particular way of accessing that uploaded file through application.Plz reply ASAP, thankx in advance.
|
|
|
|
|
Hi all,
I am trying to bind an calendar control in my repeater control. The tag for calender control i.e "<asp:calendar id='cl1' runat='server'> </asp:calendar>" comes from the database and bind in the repeater control as "<%#DataBinder.Eval(Container.DataItem, "functional_area_type")%>". But at runtime there is no calender dispalying, when I saw the code in view source i can able to see the tag "<asp:calendar id='cl1' runat='server'> </asp:calendar>" in my page.
Can any one guide me how to solve this problem?? 
Thanks all
Know is Drop, Unknown is Ocean
|
|
|
|
|
That's because you treat the ASP.NET markup as text, not a real control and you simply send out the text to the repeater. What you might need to do is to pass in this string to the ParseControl[^] method, then add the result control to the Repeater.
|
|
|
|
|
Hi
Guys, i need help,Can any one let me know that how to make the uploaded files secure, so that the user could not access the file by copying the url and then pasring it in browser to access that uploaded file, When Viewing that file, there should be particular way of accessing that uploaded file through application.
|
|
|
|
|
Hi
i want to Extract the zip File. For this i m using Csharb Ziplib Library. i tried with that it extract it but its not extracting the whole zip into folder..Pls Tell me how i can achieve this..
Thanks and Regards
Aavesh
|
|
|
|
|
|
Hello All,
I am working on a web application that uses an IFRAME. Now the IFRAME is working fine when the site was on my local machine. When I moved it to the server, it is not showing anything in the IFRAME and the IFRAME source is also blank. I have asked my friend to open the site, the IFRAME is working fine there. But with some machines...not.
What is going wrong?? Any suggestion?
Please help me out!
regards
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
Is there a way to retain the layout of the TreeView (e.g. which nodes are expanded and which are not) between postbacks. If I set a certain expansion level, it will expand all of the nodes to that level. If I set that to zero, everything is collapsed after the postback even though I've expanded the treeview to drill down to the item I'm working on. This would make the treeview almost pointless if there is no way to retain where you are currently navigation wise.
Any ideas?
Thanks for your help.
-Matt
------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
