|
Hey now, we have a whole ASP .NET forum y'know.
But, from that one time when I used asp .net about 3 years ago, I think you can just use Response.Redirect , the web browser should recognise that its a file and not a web page, and start a download.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
Hi there.
I have a TreeView in my project.
There are some nodes in it.
Now I want when user drags out a node to a folder, a text file creates in destination folder.
Do you understand what I mean ?
Can you help me ?
Thank you.
|
|
|
|
|
Y'know, I think I have a solution to your problem.
Step One: Create the text file in a temporary directory somewhere, and fill it with whatever you want.
Step Two: Add in something like this:
void TreeView1ItemDrag(object sender, ItemDragEventArgs e)
{
string[] stuff = new string[1];
stuff[0] = 'path to that text file you just made';
.
DataObject data = new DataObject(DataFormats.FileDrop, stuff);
.
this.treeView1.DoDragDrop(data, DragDropEffects.Move);
}
Windows will then move the text file from it's temporary home, to wherever the user dragged your node to.
My current favourite word is: Nipple!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
|
Hi There,
I want to insert a row into a table which is displayed in datagridview.
The table is named "WireTbl" in "WireDb" database, and has 5 fields: Code, Street, Alley, Date and Time.
Would you please help me to write a correct INSERT command for this code:
Int32 x1 = System.Convert.ToInt32(textBox1.Text);//Code
String x2 = textBox2.text;//Street
String x3 = textBox3.Text;//Alley
DateTime x4 = System.Convert.ToDateTime(textBox4.Text);//Date
DateTime x5 = System.Convert.ToDateTime(textBox5.Text);//Time
cmd1.CommandText = "Insert into WireTbl("+ "Code, "+ "Street, "+ "alley, "+ "Date, "+ "Time, "+
") VALUES('" + x1 + "', "', '"+ x2+ "','"+ x3+ "','"+ x4+ "', x5)";
Tnx
Sourie
|
|
|
|
|
use appropriate parameters to your command and change your command text according to parameter identification
i. e
Sourie wrote: cmd1.CommandText = "Insert into WireTbl("+ "Code, "+ "Street, "+ "alley, "+ "Date, "+ "Time, "+
") VALUES('" + x1 + "', "', '"+ x2+ "','"+ x3+ "','"+ x4+ "', x5)";
change to
cmd1.CommandText = "INSERT INTO WIRETBL(Code, Street, Alley, Date, Time) VALUES(@Code, @Street, @Alley, @Date, @Time)";
cmd1.Parameters.Add("@Code", SqlDbType.Int).Value = x1;
cmd1.Parameters.Add("@Street", SqlDbType.Varchar).Value = x2;
cmd1.Parameters.Add("@Alley", SqlDbType.Varchar).Value = x3;
cmd1.Parameters.Add("@Date", SqlDbType.DateTime).Value = x4;
cmd1.Parameters.Add("@Time", SqlDbType.DateTime).Value = x5;
cmd1.ExecuteNonQuery();
hope it helps
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
Thanks fort heloping me. I am using access database. Do I have to change Sql to Ole in the code you wrote me? For Example:
cmd1.CommandText = "INSERT INTO WIRETBL(Code, Street, Alley, Date, Time) VALUES(@Code, @Street, @Alley, @Date, @Time)";cmd1.Parameters.Add("@Code", OleDbType.Int).Value = x1;cmd1.Parameters.Add("@Street", OleDbType.Varchar).Value = x2;cmd1.Parameters.Add("@Alley", OleDbType.Varchar).Value = x3;cmd1.Parameters.Add("@Date", OleDbType.DateTime).Value = x4;cmd1.Parameters.Add("@Time", OleDbType.DateTime).Value = x5;cmd1.ExecuteNonQuery();
Sourie
|
|
|
|
|
Yes you have to.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Unfortunately I got Syntax Error
Sourie
|
|
|
|
|
What error message you get?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
"String was not recognized as a valid DateTime." for this line:
DateTime x4 = System.Convert.ToDateTime(textBox4.Text);//Date
Then I changed DateTime to String:For example for this line:
String x5 = System.Convert.ToString(textBox5.Text);//
cmd1.Parameters.AddWithValue("@Time", OleDbType.VarChar).Value = x5;
but this time I got this error:
Syntax error in INSERT INTO statement.
Sourie
|
|
|
|
|
DateTime.ParseExact(textBox4.Text,"MM/dd/yyyy",System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)
Sourie wrote: Syntax error in INSERT INTO statement.
Show here how do you make insert command.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
con1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=F:\WireDb.mdb";
con1.Open();
Int32 x1 = System.Convert.ToInt32(textBox1.Text);//Code
String x2 = textBox2.Text;//Street
String x3 = textBox3.Text;//Alley
DateTime x4 = System.Convert.ToDateTime(textBox4.Text);//Date
DateTime x5 = System.Convert.ToDateTime(textBox5.Text);//Time
cmd1.CommandText = "INSERT INTO WIRETBL(Code, Street, Alley, Date, Time) VALUES(@Code, @Street, @Alley, @Date, @Time)";
cmd1.Parameters.AddWithValue("@Code", OleDbType.Integer).Value = x1;
cmd1.Parameters.AddWithValue("@Street", OleDbType.VarChar).Value = x2;
cmd1.Parameters.AddWithValue("@Alley", OleDbType.VarChar).Value = x3;
cmd1.Parameters.AddWithValue("@Date", OleDbType.DBDate).Value = x4;
cmd1.Parameters.AddWithValue("@Time", OleDbType.DBTime).Value = x5;
//cmd1.ExecuteNonQuery();
cmd1.CommandType = CommandType.Text;
cmd1.Connection = con1;
cmd1.ExecuteNonQuery();
adp1.SelectCommand = cmd1;
DataTable tb1 = new DataTable();
adp1.Fill(tb1);
dataGridView1.DataSource = tb1;
con1.Close();
Dear Friend how can I learn working with Access Database in c#?
I need a complete reference to not bother you alot.
Sourie
|
|
|
|
|
you can read this link[^]
hope it helps
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
Oh thanks alot it is a good start for me.I have to read it and test ur program myself.
But another question, How I can use a datagridview to show a table's content without puting datagridview object on the form? I want to define datagridview in my code.
Sourie
|
|
|
|
|
1. create DataGridView instance
2. Set it datasource to your DataTable or DataSet
3. if you need to show the grid just add it to container control like form or panel with method "containerControl to add".Controls.Add("your datagridview") ie.
form1.Controls.Add(myGrid);
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
Wow, Finally I wrote a program .
Now I know what's the exact meaning of adapter, connection, dataset, datatable, and command.
I will try your suggestion to use datagridview also.
Sourie
|
|
|
|
|
Bravo!
It worked also. thanks alotttttttttttttt. I won't forget your kind.
may I get your help regard working with ports (Serial and USB) in c#?
Sourie
|
|
|
|
|
just follow this link[^]
there are many results here that you maybe want to know.
hope it helps
|
|
|
|
|
Hello again, according the lessons you gave me, I wrote a program that shows content of a table in a datagridview.
Now I want to sort the content of the table based a field(ASC or DEC) and show the result in that datagridview.
Database name= WirdDb, tablename= tbl2, fields: No, Code, Street, Alley, Status, Date and Time.
I want to sort the content of tbl2 according field "Street" ascendingly.
Would you please help me.
OleDbDataAdapter adapter2 = new OleDbDataAdapter();
OleDbCommand command2 = new OleDbCommand("SELECT * from tbl2"+tbl2.Street, conn);
adapter2.SelectCommand = command2;
OleDbCommandBuilder cb2 = new OleDbCommandBuilder(adapter2);
DataSet ds2 = new DataSet();
adapter2.Fill(ds2, "tbl2");
DataTable dt2 = ds2.Tables[0];
DataGridView dgv2 = new DataGridView();
dgv2.DataSource = dt2;
this.Controls.Add(dgv2);
Sourie
|
|
|
|
|
hi all,
I m a student, currently having problem on how i can start programming.
my project require the use of an measurement device and it measurement are taken from the usb port and save in notepad .txt format, i am suppose to come out with an real time graphical display of the measurement, but i have no idea how i could start on it as i am new in programming. any help or suggest would be greater appreciated. Thanks
|
|
|
|
|
You should have a library to communicate with your measurement instrument. Probably you can download it from the manufacturers web-site.
How to display the measurements on a graphical display? ZedGraph : http://www.codeproject.com/KB/graphics/zedgraph.aspx[^]
Don't bother with other plotting libraries, ZedGraph is the best.
Good luck
zafer
|
|
|
|
|
How can I set the tooltip location?
Right now I am setting a big enough tooltip size and then drawing it at desired location. Following is the code I have written.
private void Form1_Load(object sender, EventArgs e) {
ToolTip oTooltip = new ToolTip();
oTooltip.OwnerDraw = true;
oTooltip.Draw += new DrawToolTipEventHandler(oTooltip_Draw);
oTooltip.Popup += new PopupEventHandler(oTooltip_Popup);
oTooltip.SetToolTip(this.button1, "text");
}
void oTooltip_Popup(object sender, PopupEventArgs e) {
e.ToolTipSize = this.Size;
}
void oTooltip_Draw(object sender, DrawToolTipEventArgs e) {
Graphics oGx = e.Graphics;
oGx.Clear(this.BackColor);
oGx.DrawEllipse(Pens.Black, 20, 20, 20, 20);
oGx.DrawString("text",this.button1.Font,Brushes.Blue,20,20);
}
Somehow I am not too confident about this approach. Is there a better way to achieve this?
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
Use ToolTip and try these :
private void button_MouseLeave(object sender, EventArgs e)
{
toolTip1.Hide(this.button);
}
private void button_MouseMove(object sender, MouseEventArgs e)
{
toolTip1.Show("some text", this.button, e.X + 10, e.Y + 10);
}
|
|
|
|
|
Wasn't aware that .Show for a tooltip accepted a location. Thanks!
- Matthew (@CSharpByDesign)
|
|
|
|
|