|
But I can see 'DataRow' in the end of that page...will you try explain more ? As far as I understood that you're trying to Select some product rows and make their copies in that table. Is that you want ?
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
I will be not enough clear, you are right.
The matter is that I have added using "Add Data Source" wizard a file mdb with 2 tables inside.
"Valvole"
"Selezione"
the first, "Valvole", is a DB with allk products, the second, "Selezione", is a DB empty with the same structure of "Valvole". My intention is to select products and copy in the "Selection" table. After I will display in a DataGridView.
Now by default there is added in the Form1_Load and is
this.valvoleTableAdapter.Fill(this.valvoleDataSet.Valvole);
and the DataGrid is populated.
Is inside the code I write.
this.selezioneTableAdapter.Fill(this.valvoleDataSet.selezione);
I got error :
http://msdn.microsoft.com/en-gb/library/bb383961.aspx[^]
Thanks
Stefano
|
|
|
|
|
If you're using .NET Framework >= 3 I suggest using LINQ
|
|
|
|
|
|
You can also use dataview ...
just keep the datasource as the productds
And there is a filter where you can give some filtering or selection . . .
Might be this helps you ..
But still you are unclear with your question ????
|
|
|
|
|
Hi All!
using System;
using System.Collections.Generic;
using System.Runtime.InteropServices;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace FinalEventsDLL
{
public delegate void ControlEventHandler(string redirectUrl);
[Guid("E819B536-D64F-4fed-BCE7-F21650364211")]
public interface DBCOM_Interface
{
[DispId(1)]
void Hello1(string userid, string password);
[DispId(2)]
bool Hello2(string selCommand);
}
[Guid("E72E89DB-788B-4f6d-BFB1-679CC103D13A"),
InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
public interface DBCOM_Events
{
[DispId(0x60020001)]
void OnClose(string redirectUrl);
}
[Guid("EC393ACC-37A5-44da-B316-E4E367517D1C"),
ClassInterface(ClassInterfaceType.None),
ComSourceInterfaces(typeof(DBCOM_Events))]
public class FinalDLL : DBCOM_Interface
{
public FinalDLL() { }
public event ControlEventHandler OnClose;
public void Hello1(string userid, string password)
{
return;
}
public bool Hello2(string selCommand)
{
Close();
return true;
}
[ComVisible(true)]
public void Close()
{
if (OnClose != null)
{
OnClose("http://otherwebsite.com");
}
else
{
MessageBox.Show("No Event Attached");
}
}
}
}
Above is the code for my C# DLL
REGISTERED
I have registered it using
regasm D:\FinalEventsDLL.ddl /codebase /tlb
IN JAVASCRIPT
<html xmlns="http://www.w3.org/1999/xhtml">
<head> <title>C# ActiveX Test</title> </head>
<body onload="myload();">
<h1>This is Our ActiveX Test Page h1>
<script type="text/javascript" >
function myload{
var myAx = new ActiveXObject("FinalEventsDLL.FinalDLL");
if(myAx != null)
{
myAx.Hello2("sd")
}
else
{
alert("NOOOO... we failed");
}
}
</script>
</body></html>
Everything is working fine so far ,problem is
myAx.Hello2("sd")
when I call this event OnClose DLL event is fired, But how can I catch this in Javascript
I tried GOOGLE and Other Stuff's but not getting any proper answer
I also tried
function myAx::OnClose(redirectionUrl)
{alert();}
But this doesn't seems to work
Can you please help me get the proper way to Catch DLL Event in Javascript
Thanks!
Develop2Program & Program2Develop
|
|
|
|
|
Hi,
I have a (straight) line between two Point's. I want to find the nearest point on that line to another arbitrary point. How can I do this?
Thanks,
Steve
|
|
|
|
|
off top of head just loop through all points in the line and calulate the distance from that point to the 'other point' with pythagorus theory or something. shortest distance = nearest point
maybe would be easier to apply roation to the line and point first so the line is completely vertical then just use the yPos of the point and match it to the yPos within the line
Life goes very fast. Tomorrow, today is already yesterday.
modified on Wednesday, March 18, 2009 11:19 AM
|
|
|
|
|
loop through all points in the line
How to do that?
Kelvin
|
|
|
|
|
hmmm... well do a search for 'line drawing algorithm'[^] or something like that.
instead of drawing each pixel, you use each pixel to check distance with other point
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
|
 There are many ways to do many things
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
StephenWhitfield wrote: I have a (straight) line between two Point's. I want to find the nearest point on that line to another arbitrary point. How can I do this?
Wouldn't the answer to that be the adjacent points in either direction, or am I missing something? 
Ah I see, the arbitrary point is not on the line.
|
|
|
|
|
If you say the line runs between points A and B, the nearest point on this line C to an arbitrary point X is such that AB is perpendicular to CX. It's a long time since I've done any graphics work but this sounds like it should be solved with some basic trigonometry??
It definitely isn't definatley
|
|
|
|
|
|
I am writing a C# program that generates a spreadsheet. In the spreadsheet, column A contains unit numbers. Each unit may have several
products associated with it. So for example the spreadsheet will look like this.............
Unit # Team Leader Product Manufacturer
258 John Smith SONY
258 John Smith LG
258 John Smith MITSUBISHI
659 Chris Jones MAYTAG
659 Chris Jones KENMORE
659 Chris Jones AMANA
659 Chris Jones GE
8241 Sean White MOTOROLA
8241 Sean White SAMSUNG
8241 Sean White LG
8241 Sean White NOKIA
My problem is that I am trying to merge a range of cells in the C# program. I only want one unit number to show up and one team leader. So the spreadsheet would look like this instead......Can someone give me some assistance with this? Again it is in C#. Thanks!
Unit # Team Leader Product Manufacturer
258 John Smith SONY
LG
MITSUBISHI
659 Chris Jones MAYTAG
KENMORE
AMANA
GE
8241 Sean White MOTOROLA
SAMSUNG
LG
NOKIA
|
|
|
|
|
well i assume when you are inserting the data in the spread sheet that you are looping some sort of sorted list.
well define 2 variables before your loop and check them each time...
string lastUnit = "";
string lastLeader = "";
foreach(DataRow row in DT.Rows)
{
if(lastUnit == row["Unit"].ToString())
if(lastUnit == row["TeamLeader"].ToString())
lastUnit = row["Unit"].ToString();
lastUnit = row["TeamLeader"].ToString();
}
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
I am actually using two queries to get the data that I need in the spreadsheet. So does that mean that I would have to create two more for loops to read through both those rowsets? For example,
foreach(DataRow row in Research.Rows)
foreach(DataRow row in Product.Rows)
Here is the code that I've got so far......
int CurrentRow = 3;
Dictionary<string, string> myDictionary = new Dictionary<string, string>();
foreach (Dictionary<string, string> row2 in Research.Rows())
{
myDictionary.Add(row2["unit"], row2["tm_ldr"]);
}
foreach (Dictionary<string, string> row in Product.Rows())
{
oSheet.get_Range("A" + CurrentRow, "A" + CurrentRow).Formula = row["unit"];
try
{
oSheet.get_Range("B" + CurrentRow, "B" + CurrentRow).Formula = myDictionary[row["unit"]];
}
catch (Exception ex)
{
}
oSheet.get_Range("C" + CurrentRow, "C" + CurrentRow).Formula = row["prod_nm"];
oSheet.get_Range("D" + CurrentRow, "D" + CurrentRow).Formula = row["gnr_nm"];
oSheet.get_Range("E" + CurrentRow, "E" + CurrentRow).Formula = row["model"];
oSheet.get_Range("F" + CurrentRow, "F" + CurrentRow).Formula = row["mfr"];
CurrentRow++;
|
|
|
|
|
As you code sugests you are still only placing the data in the spread sheet in one line of code per column.
so you do the check before you put the data in.
at the end of each loop globally store the values for unit and teamLeader.
then before you insert unit into the spreedsheet, check if its value is the same as the last inserted unit value, if its the same dont insert the data to the spreadsheet.
Do the same for the teamLeader value
some example edit to your code....
object lastUnit = "";
foreach (Dictionary<string, string> row in Product.Rows())
{
if(row["unit"] != lastUnit)
{
oSheet.get_Range("A" + CurrentRow, "A" + CurrentRow).Formula = row["unit"];
lastUnit = row["unit"];
}
...see if this change works for the unit column. you will want to change the type of lastUnit to whatever type row["unit"] is
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
I ran the program with the following but now in the spreadsheet I am only getting one record per unit when I should have several.
foreach (Dictionary<string, string> row2 in Research.Rows())
{
if (row2["unit"] != lastUnit)
{
myDictionary.Add(row2["unit"], row2["tm_ldr"]);
lastUnit = row2["unit"];
}
foreach (Dictionary<string, string> row in Product.Rows())
{
if (row["unit"] != lastUnit)
{
oSheet.get_Range("A" + CurrentRow, "A" + CurrentRow).Formula = row["unit"];
lastUnit = row["unit"];
try
{
oSheet.get_Range("B" + CurrentRow, "B" + CurrentRow).Formula = myDictionary[row["unit"]];
}
catch (Exception ex)
{
}
oSheet.get_Range("C" + CurrentRow, "C" + CurrentRow).Formula = row["prod_nm"];
oSheet.get_Range("D" + CurrentRow, "D" + CurrentRow).Formula = row["gnr_nm"];
oSheet.get_Range("E" + CurrentRow, "E" + CurrentRow).Formula = row["model"];
oSheet.get_Range("F" + CurrentRow, "F" + CurrentRow).Formula = row["mfr"];
CurrentRow++;
}
}
oXL.Visible = true;
}
|
|
|
|
|
foreach (Dictionary<string, string> row2 in Research.Rows())
{
myDictionary.Add(row2["unit"], row2["tm_ldr"]);
lastUnit = row2["unit"];
foreach (Dictionary<string, string> row in Product.Rows()) {
if (row["unit"] != lastUnit)
{
oSheet.get_Range("A" + CurrentRow, "A" + CurrentRow).Formula = row["unit"];
lastUnit = row["unit"];
}
try
{
oSheet.get_Range("B" + CurrentRow, "B" + CurrentRow).Formula = myDictionary[row["unit"]];
}
catch (Exception ex)
{
}
oSheet.get_Range("C" + CurrentRow, "C" + CurrentRow).Formula = row["prod_nm"];
oSheet.get_Range("D" + CurrentRow, "D" + CurrentRow).Formula = row["gnr_nm"];
oSheet.get_Range("E" + CurrentRow, "E" + CurrentRow).Formula = row["model"];
oSheet.get_Range("F" + CurrentRow, "F" + CurrentRow).Formula = row["mfr"]; CurrentRow++;
}
oXL.Visible = true;
}
Copy and paste in CP does work so good with the code so i hope this is understandable.
Try this and let me know if your unit column displays as follows.
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Ok so I made that change and I'm still getting only one record per unit.
Unit # Team Leader Product Name General Name Model Manufacturer
458 John Smith 42" Plasma TV Television 89465 SONY
849 Chris Jones Top Load Washer Washer 4415574 KENMORE
1024 Sean White Wireless Phone Cell Phone 541924 MOTOROLA
Before it looked like this.......
Unit # Team Leader Product Name General Name Model Manufacturer
458 John Smith 42" Plasma TV Television 89465 SONY
458 John Smith Surrnd Snd Sys Audio System 2111 MAGNAVOX
458 John Smith 32" Plasma Tv Television 43265 LG
849 Chris Jones Top Load Washer Washer 415574 KENMORE
849 Chris Jones Frnt Load Dryer Dryer 212541 KENMORE
1024 Sean White Wireless Phone Cell Phone 541924 MOTOROLA
1024 Sean White 16 GB MP3 Plyr MP3 Player 91181 ZUNE
1024 Sean White 32 GB MP3 Plyr MP3 Player 33587 APPLE
And this is what I'm trying to accomplish by merging what's in column A by unit. So for every unit 458 I want to just show one unit number but keep all the records associtated with it. What I have now with the code you gave me only gives me one record per unit. Also I'm trying to do the same thing with the team leader.
Unit # Team Leader Product Name General Name Model Manufacturer
458 John Smith 42" Plasma TV Television 89465 SONY
Surrnd Snd Sys Audio System 2111 MAGNAVOX
32" Plasma Tv Television 43265 LG
849 Chris Jones Top Load Washer Washer 415574 KENMORE
Frnt Load Dryer Dryer 212541 KENMORE
1024 Sean White Wireless Phone Cell Phone 541924 MOTOROLA
16 GB MP3 Plyr MP3 Player 91181 ZUNE
32 GB MP3 Plyr MP3 Player 33587 APPLE
modified on Wednesday, March 18, 2009 2:11 PM
|
|
|
|
|
hi to all .......
I am using c#.net windows application. for database MSAccess.
while inserting values in the table it show that
((Number of query values and destination fields are not the same.))
data base field
id name pass
autonumber text text
and my coding
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Data.OleDb;
using System.Windows.Forms;
namespace WindowsApplication1
{
public partial class Reservation : Form
{
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\intel\\Desktop\\DB.mdb");
OleDbCommand cmd;
public Reservation()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new OleDbCommand("insert into Table1 values('" + textBox1.Text + "','" + textBox2.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("inserted");
}
}
}
while insert its not inserted.........
by
sakthi
|
|
|
|
|
What is the schema of the Table1 ?
It seems that you can insert into the table, but missing the field value for some additional required field.
insert into Table1 values('field1', 'field2', 'field3', ..., 'fieldn')
n = Table1's field's count
|
|
|
|
|
database fields r
id username password
1 sakthi sakthi
2 ramesh ramesh
3 u u
(autoincreament)
and my coding
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Data.OleDb;
using System.Windows.Forms;
namespace WindowsApplication1
{
public partial class Reservation : Form
{
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\intel\\Desktop\\DB.mdb");
OleDbCommand cmd;
public Reservation()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
cn.Open();
cmd = new OleDbCommand("insert into Table1 values('" + textBox1.Text +"','" + textBox2.Text + "')", cn);
cmd.ExecuteNonQuery();
MessageBox.Show("inserted");
}
}
}
while insert its not inserted.........
by
sakthi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
