|
Why not disable the button till you want to accept subsequent clicks.
|
|
|
|
|
Im trying to update the content in the database but it doesnt work i dont understand why.
I commented most of the code tell me if something is unclear
Get content code:
//if creating new file use textbox1 rather then the double clicked data cell
string fns = "";
if (open == false)
{
dataGridView1.CurrentCell = this.dataGridView1[0, e.RowIndex];
fns = dataGridView1.CurrentCell.Value.ToString();
}
else
{
//use filename box (file creation)
fns = textBox1.Text;
}
// get content where name == fns
SqlConnection sql = new SqlConnection(sqlcon);
a = new SqlDataAdapter("SELECT [Content], [primkey], [Name] FROM Keeper WHERE [Name] ='" + fns + "'", sqlcon);
try
{
a.Fill(s, "Keeper");
foreach (DataRow dr in s.Tables[0].Rows)
{
dataGridView2.DataSource = s;
dataGridView2.DataMember = "Keeper";
}
//get content from datagrid insert into richtextbox
dataGridView2.CurrentCell = this.dataGridView2[0, 0];
richTextBox1.Text = dataGridView2.CurrentCell.Value.ToString();
}
catch (SqlException sqlexcp)
{
MessageBox.Show(sqlexcp.Message.ToString());
}
//close connection, reset bool, bring up editor
sql.Close();
open = false;
richTextBox1.BringToFront();
Save content:
//get content from textbox insert into datagrid
dataGridView2.CurrentCell = this.dataGridView2[0, 0];
dataGridView2.CurrentCell.Value = richTextBox1.Text;
//update DB
SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(a);
a.Update(s, "Keeper");
|
|
|
|
|
try to use sql interogation
i am not sure but i think you update only one dataset not the dataBase
|
|
|
|
|
So how would i update the database?
|
|
|
|
|
I'm new in the field of software engineering and feel kinda like depressed over the rapid change and introduction of new technologies, trends etc in this field. I know that no other training methdologies can replace the learning from a good book. However to acquire knowledge from book you gotta have a good amount of time. Unfortunately due to uncertainity of my job timing I'm unable to attend any class regularly. So I though there are few sites which offers online video trainings. Can u guys quote me a good site where I can find good amount of videos trainings etc. Like learnvisualstudio.net what do you guys suggest. Offcourse I'm willing to spend some money.
Thanks.
|
|
|
|
|
|
Read articles on CP. You always learn something new!!
_____________________________________________________________________
Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.
The Enlightenment Project (paraphrased comment)
Visit Me at GISDevCafe
|
|
|
|
|
Some employers will pay for you to attend classes to further hone skills needed to perform your job. If you do gain employment with one of these companies, ask if you could take some programming courses from a local university. They might be willing to help, and it might be free for you.
Good luck! 
|
|
|
|
|
But guys what about these Video training sites? any suggestion on that or any good site you wanna share.
|
|
|
|
|
|
What is Diffgram? How it is used ?
Regards,
LEE
|
|
|
|
|
A DiffGram is an XML format that is used to identify current and original versions of data elements. Since the DataSet uses XML format to store and transfer data, it also use DiffGrams to keep track of the original data and the current data. When a DataSet is written as a DiffGram, not only a DiffGram stores original and current data, it also stores row versions, error information, and their orders.
For more Info abt the DiffGram
(1)Msdn2[^]
(2)Diffgram[^]
Regards,
Satips.
|
|
|
|
|
|
Dear all,
Hi in my application i have one gif file i need to convert that gif file to .doc formate can any body can give guidance in this situation
thanks & regards,
easwar.
|
|
|
|
|
.doc is used to store text documents, .gif is used to store image infomation. Are you saying you want to place a .gif image inside a new .doc? If so, search for "Tools for Microsoft Office"
|
|
|
|
|
Dear All,
PLease let me know how to display hierarchical data in Datagridview control of Windows forms. I want the Datagridview to display hierarchical data .
Thanx,
|
|
|
|
|
The article by Addison-Wesley in CP here[^] may help you in displaying the hierarchial data in DatagridView control of windows forms.
Regards,
Satips.
|
|
|
|
|
What is Bubble Event? How it is used?
Regards,
LEE
|
|
|
|
|
Bubble events occur in WPF only. It means the event bubbles up to controls above the one that raised it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi
I have 6 datatables with me in my application.These datatables were fetching from a server machine
Now i want to insert these items into a local database
Right now i am using foreach method to search all the rows and inserting each one into the local database.
Is there any method to import this datatable directly to a ms access database?
Please reply soon
|
|
|
|
|
Check out bulk insert[^]. I don't know if MS Access supports it, however.
|
|
|
|
|
Have you thought about migrating to Sql Server 2005 express? Then you could use SMO to create the tables and even the database and then use SQL Bulkcopy to move the data. MS access will greatly limit your ability to perform higher end database functions.
_____________________________________________________________________
Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.
The Enlightenment Project (paraphrased comment)
Visit Me at GISDevCafe
|
|
|
|
|
But i want to use msaccess,its a small desktop application. The sql server may not be in the end machine.
Can you any other technique?
My small attempt...
|
|
|
|
|
i need the full path of a fille whit the fileupload controle
i use
String filename = FileUpload1.PostedFile.FileName;
but i only get the name and not the path
but i work in internet explorer and not in firefox.
How can i solve this.
|
|
|
|
|
turbster wrote: i need the full path of a fille whit the fileupload controle
Why do you think that you need the full path?
turbster wrote: but i only get the name and not the path
Do you have any antivirus/firewall installed? If so, it might remove the path for security reasons. It's also possible that Firefox does this by itself, for the same reason.
There is no reason that the web browser should send the complete path to the uploaded file anyway. It only exposes more information than neccesary.
---
single minded; short sighted; long gone;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
