Re: Newbie Question - C# Discussion Boards

Re: Can we get program's number line after compiling the source ?

23-Jun-08 2:07

Thanks Luc Pattyn.

Freshman

Luc Pattyn23-Jun-08 2:08

Luc Pattyn

23-Jun-08 2:08

you're welcome.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Voting for dummies? No thanks. Dead | X|

Re: Can we get program's number line after compiling the source ?

Mohammad Dayyan23-Jun-08 2:48

23-Jun-08 2:48

I must using

StackFrame CallStack = new StackFrame(0, true);
Console.Write("File: " + CallStack.GetFileName() + ", 
Line: " + CallStack.GetFileLineNumber());

Freshman

Newbie Question

kruegersck22-Jun-08 12:59

22-Jun-08 12:59

I am trying to update my Access and I am recieving an Error:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace ProspectorV100
{
public partial class frmProspectMaint : Form
{
OleDbConnection cnADONETConnection = new OleDbConnection();
OleDbDataAdapter daContactsCombo;
OleDbCommandBuilder cbContactsCombo;
DataTable dtContactsCombo = new DataTable();
int row;
long intContactID;

public frmProspectMaint()
{
InitializeComponent();
}

private void frmProspectMaint_Load(object sender, EventArgs e)
{
cnADONETConnection.ConnectionString =
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Prospector\Database\prospect.mdb";
cnADONETConnection.Open();
daContactsCombo =
new OleDbDataAdapter("Select * From Contacts Order by Last_Name", cnADONETConnection);
OleDbCommandBuilder cbContactsCombo = new OleDbCommandBuilder(daContactsCombo);
daContactsCombo.Fill(dtContactsCombo);
this.LoadSearchBox();
}

private void LoadSearchBox()
{
for (int x = 0; x < dtContactsCombo.Rows.Count; x++)
{
tlsSearch.Items.Add(dtContactsCombo.Rows[x]["Last_Name"].ToString() + ", " +
dtContactsCombo.Rows[x]["First_Name"].ToString());
tlsSearch.AutoCompleteCustomSource.Add(dtContactsCombo.Rows[x]["Last_Name"].ToString() + ", " +
dtContactsCombo.Rows[x]["First_Name"].ToString());
}
}

private void frmProspectMaint_FormClosed(object sender, FormClosedEventArgs e)
{
cnADONETConnection.Close();
cnADONETConnection.Dispose();
}

private void tlsSearch_SelectedIndexChanged(object sender, EventArgs e)
{

row = tlsSearch.SelectedIndex;

intContactID = Convert.ToInt32(dtContactsCombo.Rows[row]["Contact_ID"].ToString());
txtFirstName.Text = dtContactsCombo.Rows[row]["First_Name"].ToString();
txtLastName.Text = dtContactsCombo.Rows[row]["Last_Name"].ToString();
txtCompany.Text = dtContactsCombo.Rows[row]["Company_Name"].ToString();
txtJobTitle.Text = dtContactsCombo.Rows[row]["Job_Title"].ToString();
}

private void tlsSave_Click(object sender, EventArgs e)
{
//If there is existing Data Update it
if (row >= 0)
{
dtContactsCombo.Rows[row]["Contact_ID"] = intContactID;
dtContactsCombo.Rows[row]["Last_Name"] = txtLastName.Text;
dtContactsCombo.Rows[row]["First_Name"] = txtFirstName.Text;
dtContactsCombo.Rows[row]["Company_Name"] = txtCompany.Text;
dtContactsCombo.Rows[row]["Job_Title"] = txtJobTitle.Text;
daContactsCombo.Update(dtContactsCombo);
}
}

}
}

As I stated before I am new to C# and any help would be appreciated.

Gareth H22-Jun-08 13:03

Gareth H

22-Jun-08 13:03

kruegersck,

What is the error? and at which line does it happen?

Regards,
Gareth.

(FKA gareth111)

kruegersck22-Jun-08 13:09

22-Jun-08 13:09

Sorry - I get an SQL Error at the line: daContactsCombo.Update(dtContactsCombo);

Syntax error in query expression '((Contact_ID = ?) AND ((? = 1 AND First_Name IS NULL) OR (First_Name = ?)) AND ((? = 1 AND Last_Name IS NULL) OR (Last_Name = ?)) AND ((? = 1 AND Company_Name IS NULL) OR (Company_Name = ?)) AND ((? = 1 AND Job_Title IS NULL) OR (Job_Title = ?)) AND ((? ='.

Thanks for all your help

Christian Graus22-Jun-08 15:12

22-Jun-08 15:12

kruegersck wrote:
((? = 1

I don't think it works like that.

kruegersck wrote:
((? =

Definately this won't work, you have two brackets ( for no good reason ) and they are not closed.

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

kruegersck22-Jun-08 16:28

22-Jun-08 16:28

That is the error message I am getting????

Christian Graus22-Jun-08 18:27

22-Jun-08 18:27

Yes, so the string you're using for your query, is wrong. That is what I am telling you.

kruegersck23-Jun-08 2:58

23-Jun-08 2:58

Are there any good examples of doing this using Access?

Thanks Again.

Christian Graus23-Jun-08 11:36

23-Jun-08 11:36

I'm not sure what you mean by 'doing this', it looks to me like you're asking a SQL question and all you need to do is close your brackets. Where is the issue ?

Drog and Drop question ?

Mohammad Dayyan22-Jun-08 11:17

22-Jun-08 11:17

Assumption , we have a TreeView in C# form and each node of TreeView contains web address.

Now, I want drag a node into the IE browser as IE opens its web address.

How can we do it ?

Freshman

Christian Graus22-Jun-08 12:20

22-Jun-08 12:20

I guess the question you need to ask is, what format of drag and drop, if any, does IE support. If it has support for something like this, you need to write code to conforms to what IE expects.

Mohammad Dayyan22-Jun-08 12:28

22-Jun-08 12:28

Thank you Christian.

Christian Graus wrote:
you need to write code to conforms to what IE expects.

It is my problem exactly Confused | :confused:

Can you help me ?

Freshman

Christian Graus22-Jun-08 12:31

22-Jun-08 12:31

A quick google leads me to believe that IE has a drop event handler, so if you had IE in your own window, as a control, you could handle it. I don't see anyting else, but if you try to google it, you may find something.

Mohammad Dayyan22-Jun-08 12:39

22-Jun-08 12:39

OK, Thanks

Freshman

modified on Sunday, June 22, 2008 6:54 PM

Anthony Mushrow22-Jun-08 14:50

Anthony Mushrow

22-Jun-08 14:50

OK, i finally got it. IE expects Files (which we already knew right?). After a little investigation it turns out the a FileDrop is just an array of strings (usualy with just one string in, go figure).

So, simple enough:

void TreeView1ItemDrag(object sender, ItemDragEventArgs e)
{
  string[] stuff = new string[1];
  stuff[0] = @"http://www.google.co.uk"; // or e.Item.ToString() or however you've got your address in there
.
  //Create a new data object with the FileDrop type
  DataObject data = new DataObject(DataFormats.FileDrop, stuff);
.
  //And IE only wants Copy, it doesn't like move or whatever
  this.treeView1.DoDragDrop(data, DragDropEffects.Copy);
}

So, IE will get this info, check the array of strings for the file to open, find your web address, and open it.

My current favourite word is: I'm starting to run out of fav. words!

-SK Genius

Game Programming articles start -here[^]-