|
PCP.NET wrote: First, sorry if this is not the right place for this offer.
Ok, but it's obviously not the right place, and I think you know that!
P.S.:PCP.NET wrote: coding 2 - 3 months
If you mean man months, I hope you have no deadline then!
All the best,
Martin
|
|
|
|
|
This is not the ideal place for this, there is a dedicated Jobs forum IIRC.
Out of interest, and idea on pay for this?
|
|
|
|
|
//Change the column names.
int i;
for (i =0;i<= (ds.Tables[0].Columns.Count - 1);i=i+1)
ds.Tables[0].Columns[i].ColumnName = "C:" + i.ToString();
colname = ds.Tables[0].Columns[0].ColumnName;
//display the data in the first row of the first column
Console.WriteLine(ds.Tables[0].Rows[0][colname.ToLower()]);
I want to get rid of int i; (integer) and replace it with string which will give me e.g.
C:A for first column
C:B for second column
Can anybody please help me???
|
|
|
|
|
So you want to display A,B,C instead of numbers? What if you run out of letters? 
|
|
|
|
|
Hi to all.
Does any one work with TOC in Wood documnet through c# code.
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
Look up documentation on Office Interop classes and there should be something there about TOC...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
sorry iam new to this kind of forums.here after i will keep discussion in the same thread.
i tried as u said and given the code also but still the same kind of error is coming----The ConnectionString property has not been initialized
ERROR IS The ConnectionString property has not been initialized IN CON1.OPEN().Plz help in solving these problem, iam a fresher.Thanks in advance
public partial class detail : System.Web.UI.Page
{
//string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DataFinal.mdb;User Id=admin;Password=;";
String con1 = "Provider=Microsoft.JET.OLEDB.4.0;data source=path\\db1.mdb";
String con2 = "Provider=Microsoft.JET.OLEDB.4.0;data source=path\\db2.mdb";
protected void Page_Load(object sender, EventArgs e)
{
}
private void InitializeComponent()
{
}
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection con1 = new OleDbConnection();
con1.Open();
DataTable tables1 = con1.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow row in tables1.Rows)
DropDownList1.Items.Add(row[1].ToString());
OleDbConnection con2 = new OleDbConnection();
con2.Open();
DataTable tables2 = con2.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow row in tables2.Rows)
DropDownList2.Items.Add(row[1].ToString());
}
-- modified at 2:20 Friday 24th August, 2007
|
|
|
|
|
I would have attempted to answer this AGAIN had you not been rude enough to delete your original message below.
In future please keep discussion on the same topic to the same thread.
|
|
|
|
|
I have already answered the same question several messages below. I guess you are the same person and you have deleted the message? Don't double post
|
|
|
|
|
you must pass the strConn in the oledbconnection() constructor..
or set the
con1.connectionstring = strconn
|
|
|
|
|
His previous nice was 'shemvignesh'. Now it is 'svignesh'. Looks like Numerology/Nameology suggestion and hence he is trying to debug that issue first and thne debug this ConnectionString issue. 
|
|
|
|
|
Hi
can anyone please help me of how to craete a class that will connect dotnetCharting with database.
or namespace that i can use to access dataengine
thanx
Mamphekgo
|
|
|
|
|
System.Data
ADO.NET is the thing to google if you don't know how to connect to a database. There's also tons of articles here and elsewhere
Christian Graus - Microsoft MVP - C++
"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 )
|
|
|
|
|
i using crystal report in my project. i want to add page wise total for a column(stock) please give me a idea.....
|
|
|
|
|
You should be able to have a running sum in the header or footer of the report.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi all,
In my project i am retriving some values from database. For eg: id,brand,status,comments.
After retriving this i am storing the values in the dataset. My doubt is, i want to get the count of records with the same brand, and also i want to bind the those records into datagridview which come under an specified category form the dataset.
For eg:
id brand status comments
1 aaa 1 test
2 bbb 1 test
3 aaa 1 test
4 ccc 1 test
5 bbb 1 test
6 aaa 1 test
7 aaa 1 test
In the above i want to dispaly only the record with brand "aaa" in datagridview, and want to display the count of "bbb","ccc" in a label control.
Plz any one help.
Thanks in advance
Know is Drop, Unknown is Ocean
|
|
|
|
|
You should change your SQL statement..
SELECT brand, COUNT(status), comments FROM Table1 GROUP BY brand,comments
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
hi Michael,
thank you very much for your suggestion., But i need it to be done using datatable, dataview. So plz suggest me an option to like so.
Thank you very much
Know is Drop, Unknown is Ocean
|
|
|
|
|
How did you bind the data to DataView?
In SQL statment, you have to change the statment like above....
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
Dear sir,
how i create a DB Connection module which will read Data Source (IP ) from .txt File. I only write IP in the .txt file and call that method from form load.
i done it in VB but i can't in C#.
plz help me
Shafik
|
|
|
|
|
hi,
imagine that i have five arraylists(ShapeTypeList,ColorList,CoordList,SizeList,PathList). All contains different types such as enum,Color,Point[] and etc. This arraylist is used in the form to store information on the Shapes to be drawn onto the form. Then, there is a Save function which is used to store all the informations in the arraylist using xml. I've create a AllData class inorder to serialize the class to an xml file. Can anybody give me some guides or tips on how to use xmlserializer to save the arraylist into xml file? the format i'm looking for is as below:
<RootClass>
<Arraylist1>
<ArrayItem1a>....</ArrayItem1a>
</ArrayList1>
<ArrayList2>
<ArrayItem2a>....</ArrayItem2a>
<ArrayItem2b>....</ArrayItem2b>
.......
........
........
</ArrayList5>
However other format also acceptable as long as i can deserialize it later.
Thanks in advance.
-- modified at 3:59 Wednesday 22nd August, 2007
|
|
|
|
|
|
|
You can either pass connection string as a parameter to the constructor or set the ConnectionString property of OleDbConnection.
For example:
<br />
string connstring="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"<br />
OleDbConnection con1 = new OleDbConnection(connstring);<br />
OR:
<br />
string connstring="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"<br />
OleDbConnection con1 = new OleDbConnection();<br />
con1.ConnectionString=connstring;<br />
If you have problem in constructing the connection string itself then this website will help you:
Connection Strings[^]
|
|
|
|
|
shemvignesh wrote: OleDbConnection con1 = new OleDbConnection();
con1.Open();
you're missing a line in there which tells the OleDbConnection how and where to connect to a database.
the line will look like:
con1.ConnectionString = "Your connection string here....";
See www.connectionstrings.com[^] for info on what to write in there.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
