|
Hi Guy
very easy way, if used OleDbCommand to insert qith ExcuterNonQuery().
and u have done a mistake, dont use password in column name directlly.
DataRow drNewRow = m_dtPassword.NewRow();
drNewRow["UserName"] = txtboxUserName.Text;
drNewRow["Password"] = cipherText;-----This is
i have give two suggestion to u.
1.use the index instead of the column name.
2. if any field came like keyword, use like this drNewRow["[Password]"]
Thanks
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
Thanks guys, I changed the column name to something else and it worked fine. Much appreciated.
|
|
|
|
|
I want to make a program that when executed show a splash screen (while searching for specified files in background) and any keyborad or mouse input is not allowed during this process.
How can i do this please help.
|
|
|
|
|
lifeh2o wrote: any keyborad or mouse input is not allowed during this process.
That sounds a bit odd, why would you want to do that? The user might not like having their system locked while your software is looking for files. Anywho, that will require some P/Invoking of some Win32 API's
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
("The user might not like having their system locked while your software is looking for files")
I m not making it for "users". I just want some practice on stopping keyboard or mouse input. For example when we apply a visual style on windows XP no input is allowed while applying.
I need help.
|
|
|
|
|
Hi all,
How to convert a string value in to a decimal value in c#.net.Any one please suggest me. I dnt knw whether this is ideot thing or not..
for eg string "1.888" in to a decimal value 1.888
Please suggest me a solution
Thanks in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
Decimal.Parse or Decimal.TryParse
|
|
|
|
|
If you (for some very specific reason) really want a Decimal value, you use the Decimal.Parse method:
Decimal num = Decimal.Parse("1.888");
For most numerical purposes the hardware supported floating point data type Double is the better choice:
Double num = Double.Parse("1.888");
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Convert.ToDecimal("0.1337")
Regards,
Thomas Stockwell
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.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
Can listboxes be linked?
I need to create several listboxes on a form that have their scroll bars related.
At present one listbox will contain commands and another listbox will contain responses.
When either the commands or responses listbox is scrolled the other one should scroll an equal amount.
I may be missing out on the obvious here, any help that points me in the right direction would be gratefully received.
You always pass failure on the way to success.
|
|
|
|
|
There is no inherent listbox linking support
led mike
|
|
|
|
|
Thanks,
I will find some way around this.
Regards
Guy
You always pass failure on the way to success.
|
|
|
|
|
I am updating an excel spreadsheet using OleDbConnection and OleDbDataAdapter.
This seems to be very quick if the excel file is closed.
Now, I would like to make sure that is the case.
i.e:
if the file is open, then save and then close.
go through the update as it is doing now
open the excel file again.
Question.
How can I check if the file is open?
save and close
and then re-open.
Thanks
|
|
|
|
|
not sure if this will help you or not, but what the hell . . .
If you use the MS Office Interop classes (MSDN 1[^] MSDN 2[^]) there's a property in the Workbook class that might help you. The simplest way of opening an Excel file is
ApplicationClass excelApp = new ApplicationClass();
_Workbook myWorkbook = excelApp.Workbooks.Open(@"C:\test.xls", Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
and then you'll have available the myWorkbook.ReadOnly property that tests several different conditions, one of which is if the file is already open in Excel. If the file is already open or otherwise un-editable then this property will return true and you'll know you have to yell at your user and tell him/her to close it before you can modify it.
|
|
|
|
|
hi i want to set size of form according to system resolution ... how to do that in windows application
Thanks & Regards,
Prashant B. Lavate
Software Engineer
Mobile : +919423872257
Pune(India)
|
|
|
|
|
|
This should do:
int x = SystemInformation.PrimaryMonitorSize.Width;
int y = SystemInformation.PrimaryMonitorSize.Height;
Enjoy
|
|
|
|
|
HI Guy
Nice way, get Monitor resolutions values.after ajust with form value and based on the resoltions.or try with autoscale property for form.
Thanks
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
I have requirement storing and retriving images from sqlserver.
insertion works fine but getting images from sqlserver not working . so how we can implement asp.net web application using c#
|
|
|
|
|
rajeshkumar g wrote: insertion works fine but getting images from sqlserver not working
Why isn't it working? What have you tried?
If you don't supply sufficient information relating to your problem, you won't get any help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
following code works fine in vb.net application but in c# application doesnot work because myDataReader.Item method not in c#. so how this one implemented in c#
Dim myConnection As New SqlConnection("server=latitude-be8a47;database=tempdb;uid=sa;password=sa")
Dim myCommand As New SqlCommand("Select * from Person", myConnection)
Try
myConnection.Open()
Dim myDataReader As SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))
Loop
myConnection.Close()
Response.Write("Person info successfully retrieved!")
Catch SQLexc As SqlException
Response.Write("Read Failed : " & SQLexc.ToString())
End Try
|
|
|
|
|
rajeshkumar g wrote: myDataReader.Item method not in c#. so how this one implemented in c#
myDataReader["myfield"]
BTW, you could have found this information yourself had you read the documentation or searched Google.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
Without a better explaination of what is wrong it will be hard to help.
How do you know they are inserted the right way?
In ASP.NET to use dynamic images, you need to create an ASPX page that will output an image as its sole purpose.
I have created applications that store files in databases and read them back out, I should be able to help you out pretty easily.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
following code works fine in vb.net application but in c# application doesnot work because myDataReader.Item method not in c#. so how this one implemented in c#
Dim myConnection As New SqlConnection("server=latitude-be8a47;database=tempdb;uid=sa;password=sa")
Dim myCommand As New SqlCommand("Select * from Person", myConnection)
Try
myConnection.Open()
Dim myDataReader As SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))
Loop
myConnection.Close()
Response.Write("Person info successfully retrieved!")
Catch SQLexc As SqlException
Response.Write("Read Failed : " & SQLexc.ToString())
End Try
|
|
|
|