|
At a guess it is trying to use the same stream (i.e. strLocal) it is a different file but that does not mean there is more than one stream.
That depends on where strLocal is declared and how the code that declares it is called. And that we don't know since it's not in your post.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
|
ankitjain1110 wrote: can anyone give me the code plz
No.
But if you research the SELECT Statement (SQL) you will find plenty of examples of extracting specific information, and if your research the DataGridView or DataGrid , depending on the version of VS and whether it is a Web or Windows Forms Application, you will find lots of examples for that part.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
A little advise on the type of questions you are asking:
1) Please check the spelling of the message before you submit to the world. Broken language is particularly very disgusting and irritating.
2) I believe you have a good, comfortable QWERTY keyboard and are not constrained to work from a mobile keypad or a like device. Hence avoid Text Speak for normal queries.
3) Discussion forums are intended to support your earnest endeavor and honest initiatives towards the task on hand by assisting you to elegantly confront and tackle any problems that thwart you from reaching the desired goal. Misusing/Abusing the forum as a substitute for homework is not going to help you go any farther.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!
|
|
|
|
|
|
Start writing code for you by yourself and when you stuck in specific problem then post here,someone will hand you.
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.
www.aktualiteti.com
|
|
|
|
|
sorry for asking directly the code. but have triead a lot. like i was just selecting the datagrid view.then after adding the datasource i tried the edit column and add column part...but am lost...no values is being displayed.i can do the codin till extracting the values into a datareader..what to do after that.
|
|
|
|
|
Hi,
How to create FTP site using "System.DirectoryServices" in C#? I want to set all the properties like IP,PORT , log directories , etc..
How can we create and set properties using "System.DirectoryServices" ? I would highly appreciate your help.
Thanks,
Mike.
|
|
|
|
|
|
hi,
I'm sorry to ask this, is creating a virtual directory same as creating ftp site on IIS server? I mean I want to programitically add properties like, ip address, port, logging format, etc.. how this can be accomplished?
Thanks,
Mike
|
|
|
|
|
Hi
I'm creating a WPF application, but I also integrated crystal reports into my application. The problem is, the form that the reports are shown on uses a standard Windows Form. I want my reports to have the same look and feel as the rest of my application. Can I customize this standard Form e.g. change the standard border to a nicer border with rounded edges, change the color of the form, maybe making it transparent, etc. etc?
|
|
|
|
|
Trying to revamp the form as you describe is more hassle than it's worth.
I would suggest that you use a standard WPF window and host your winfrom content in a WindowsFormsHost[^].
Latest toy built for fun: Web Lens
Best feature: Full size images when using Google image search.
|
|
|
|
|
i have a datagridview with columns group,description,unit_price,amount....i want only the first three columns of the data grid view to be populated..the fourth column is filled using calculations.is it possible to bind this to datatable ???
|
|
|
|
|
you can achieve this scenario in the database itself...
Code:
create table test_tab (m1 numeric, m2 numeric, m3 numeric)
insert into test_tab values (1,2,3)
insert into test_tab values (4,6,8)
insert into test_tab values (5,7,9)
select m1,m2,m3 , (m1+m2+m3) as tot from test_tab
<pre>
<div class="ForumSig">Padmanabhan
My Articles:
<a href="http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=5686247">Articles</a>[<a href="http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=5686247" target="_blank" title="New Window">^</a>]
My latest Article:
<a href="http://www.codeproject.com/KB/office/Word_Automation_Part1.aspx">Word Automation</a>[<a href="http://www.codeproject.com/KB/office/Word_Automation_Part1.aspx" target="_blank" title="New Window">^</a>]</div>
|
|
|
|
|
How to bind two data tables which are in the same dataset to a datagrid????Below is tha code i've written so far
OleDbDataAdapter da_pay = new OleDbDataAdapter();
DataSet ds_pay = new DataSet();
OleDbCommand pay_cmd = new OleDbCommand("select Group from group_details where [Group]='"+descriptiondpdwnlist .SelectedItem .Value +"'",con2);
da_pay.SelectCommand = pay_cmd;
da_pay.Fill(ds_pay,"bill_group");
DataTable pay_dt=ds_pay .Tables ["bill_group"];
OleDbCommand pay_cmd1 = new OleDbCommand("select Description from description_details where [Description]='"+descrptndpdnlt .SelectedItem .Text +"'",con2);
da_pay.SelectCommand = pay_cmd1;
da_pay.Fill(ds_pay ,"Bill_description");
DataTable pay_dt1=ds_pay .Tables ["Bill_description"];
con2.Close();
|
|
|
|
|
public void GridBind()
{
DataTable dtfirst;//your first datatable
DataTable dtsecond;//your second datatable
DataTable dtOverall = new DataTable();
dtOverall.Columns.Add("id");//name of the first table column
dtOverall.Columns.Add("name");//name of the first table column
dtOverall.Columns.Add("email");//name of the second table column
dtOverall.Columns.Add("phone");//name of the second table column
//..
//..
//..
int first = dtfirst.Rows.Count;
int second = dtsecond.Rows.Count;
int overAllTableCount = (first > second) ? first : second;
for (int i = 0; i < overAllTableCount; i++)
{
int id = 0;//according to the column name and datatype use here
string name = string.Empty;
string email = string.Empty;
string phone = 0;
//...
//..
//..
if (i < first)
{
id = int.Parse(dtfirst.Rows[i]["id"].ToString());
name = dtfirst.Rows[i]["name"].ToString();
}
if (i < second)
{
email = second.Rows[i]["email"].ToString();
phone = int.Parse(second.Rows[i]["phone"].ToString());
}
DataRow drOverall = dtOverall.NewRow();
drOverall["id"] = id;
drOverall["name"] = name;
drOverall["email"] = email;
drOverall["phone"] = phone;
dtOverall.Rows.Add(drOverall);
}
}
//hope you understood
|
|
|
|
|
Hello,
In my application i am having two forms.
In the first form i am having a textbox and in the
second form i am having a datagridview and a button back.
when the button back is clicked i like to get the data from the
datagridview to the textbox in the first form.
Please help me how i can do this.
I have no sound about this....plz help me
Thanks in advance
|
|
|
|
|
Just showing example :
public class Form1 : Form
{
...
public string MyText
{
set { this.textBox1.Text = value; }
}
...
}
public class Form2 : Form
{
private Form1 form1;
public Form2(Form1 form1)
{
this.form1 = form1;
}
private void buttonBack_Click(object sender, EventArgs e)
{
this.form1.MyText = "Data from DataGridView here...";
}
}
|
|
|
|
|
This is NOT a good way to do it as now Form2 is coupled to Form1. Also, what if there are hundreds of objects that need the data? Are you going to have hundreds of constructor overloads?
The correct way to do this is to raise an event in Form2 that Form1 (and any other interested parties) subscribes to. If any data needs to be passed, then a custom class derived from event args should be used with that data being passed as a property. This is the way all the classes provided by Microsoft do it, with good reason.
A quick example:
using System;
using System.Windows.Forms;
public class Form1 : Form
{
public Form1() { }
public void ShowNewForm2()
{
Form2 form2 = new Form2();
form2.CustomEvent += new EventHandler<CustomEventArgs>(form2_CustomEvent);
form2.Show();
}
void form2_CustomEvent(object sender, CustomEventArgs e)
{
}
}
public class Form2 : Form
{
public event EventHandler<CustomEventArgs> CustomEvent;
public Form2() { }
protected virtual void OnCustomEvent(CustomEventArgs e)
{
EventHandler<CustomEventArgs> eh = CustomEvent;
if (eh != null)
eh(this, e);
}
public void PerformCustomEvent()
{
OnCustomEvent(new CustomEventArgs(123));
}
}
public class CustomEventArgs : EventArgs
{
public CustomEventArgs(int yourData)
{
YourData = yourData;
}
public int YourData
{
get;
private set;
}
}
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
thank you for giving me an idea.
i got it
|
|
|
|
|
See my reply to stancrm - there is an example there that gives you the idea.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Thank you for giving me a nice example.
|
|
|
|
|
i have datatable which is returned from storedprocedure,now i want to pass that data table's values to crystal report to view,
i have tried through parameters but can't get desired result.the database fields i cant assign to report because the values come from different sources in storedprocdure
Regards
|
|
|
|
|
You need to create a strongly typed DataSet in your project, one that represents the data schema from the stored procedure.
Then you need to base your report off the strongly typed DataSet.
Then just assign the DataSource property of the CrystalReport to the instance of the DataSet returned from your your stored procedure.
If at first you don't succeed ... post it on The Code Project and Pray.
|
|
|
|
|
i am on a windows project and i applied backgroundimage to all the forms earlier. And now when i want to apply another new background image to a form then , i can see the new image as background image to a form in visual studio but at the runtime no image is displayed, and the form is displayed with background color but not with the image. After that through code also i tried using imagelist . Then indexoutofrange exception is coming.
Please suggest me the required answer. Urgent.
|
|
|
|