C# Discussion Boards - CodeProject

hi freinds

I need to call an stored procedure from c# code for ssis package, stored procedure has one output parameter

i have creaded one oledb command comonent using C# with this oledb command i want to execute the stored procedure

i have set the oledb command's sql command property like

DestErrorInst.SetComponentProperty("SqlCommand", "exec spInsertErrors ?, ?, ?, ? out");

now i want to map or read this output parameter values

how can i achieve this?

thanks

Hi all,

In my repeater control i have done a simple if condition as below

]]>
<%{ %>
<td>
Invoiced
</td>
<%}else{ %>
<td>
Not Invoiced
</td>
<%} %>

When i run this code i am getting a error as below

The name 'Container' does not exist in the current context

What is the reason for this error and how to solve this.

Please suggest me.

Thank you

Know is Drop, Unknown is Ocean

It is because you are asking in the wrong forum. Try ASP.NET.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 beta 1 - out now!
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

There are some issue around this answer

In My Example:
![CDATA[<%# for (int i = 0; i < System.IO.Directory.GetFiles(Server.MapPath(string.Format("~/Img/Att/{0}/", ((System.Data.Common.DbDataRecord)Container.DataItem)["ID"], "*.jpg"))).Length; i++)%><%{%>

<%= i %>

<%}%>]]>

I receive these errors:
Error 2 Invalid expression term ',' Destination.aspx 3 1
Error 3 Invalid expression term 'for' Destination.aspx 188 74
Error 4 The name 'i' does not exist in the current context Destination.aspx 188 244
Error 5 ; expected Destination.aspx 188
Error 6 ; expected Destination.aspx 188
Error 7 Invalid expression term ')' Destination.aspx 188
Error 8 ; expected Destination.aspx 188
Error 9 Invalid expression term ')' Destination.aspx 188

Do you have any idea ?

if I need to maximize picture box & list view as same as window form

how can i do?

please give hint or tip to me

thank so much...

If I got you right, you can set the control's Dock property to Fill.

You can also play with Anchor points to resize controls with the parent form.

Regards,
Lev

Hi ,

I want to change Startup object of Project at runtime. I want to use
VSLangProj.ProjectProperties namespace to set StartupObject Property of Project at run time. If anybody then please send me some hint.

Thanks
ab

Hi,
I want a code to capture the present GMT in C#.Net.

No

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

DateTime.UtcNow[^]

Developer Day Scotland 2 - Free community conference

Recent blog posts:
*Throwing Exceptions
*Training Developers
* Method hiding or overriding - or the difference between new and virtual

Windows API has 2 functions that returns time :
- GetLocalTime() returns the current local time.
- GetSystemTime() returns the UTC(GMT) time.

Cheers!!
Brij

i am using windows aplliction using c#...

i have 1000 records in my table....
which has fields CUSTOMER_ID,NAME,CITY,SALARY.....

I HAVE TO SEE ONLY THE CUSTOMER WHO ARE LIVING THE CITY CALLED "DOWNTOWN"

HOW CAN I SEE THIS IN DATAGRIDVIEW...

PLS REPLY...
GIVE ME SUGGESTION OR SAMPLE CODING...

THNX IN ADVANCE

on load of the screen or where ever you are loading the grid
just before binding to the dataGrid you can loop through each row and check the condtion where Rows[0].Cells[0].tostring()=="xyz"

vikas da

are you insane? I would hate to see crap like that in a program i have to maintain...

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

are you mental.. go to some hospital.. Smile | :)

bloddy this was just a suggestion
if you know something better then me .. did i stop you to answer...

vikas da

tasumisra wrote:
did i stop you to answer

Nope, but there are much easier ways Smile | :)

see my reply...

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

I have seen your answer ... but some times we can't hardcode any querry from sql command it will cost more if u need to change your condition.

anyway if you have ever used WCF then in services
we are binding the reader object with our business object for each row that time we can filter it out more easily...

vikas da

tasumisra wrote:
some times we can't hardcode any querry

In that case, create a stored procedure for SQL and call that in your application... problem solved Smile | :)

OR

Use the DataView object, i use this frequently to filter data dynamically

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

Harvey Saayman wrote:
In that case, create a stored procedure for SQL and call that in your application... problem solved

what if you dont have acess to the stored proc....??? Smile | :)

its written in COBOL and residing in Mainframe...

vikas da

tasumisra wrote:
COBOL

Then you get your ass out of the C# forum Laugh | :laugh:

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

do you know ??????

a stored proc can be written in COBOL..

and sorry you can acess these stored proc using your ass..from C# also

vikas da

Calm d0wn dude, i was JOKING... sheesh

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

Hi,

Why don't you use the BindingSource Filter property?

For example, you can have myDataSource.Filter = "City = 'DOWNTOWN'"

Here is the example from MSDN:

private void PopulateDataViewAndFilter() {
DataSet set1 = new DataSet();

// Some xml data to populate the DataSet with.
string musicXml =
"" +
"<music>" +
"<recording><artist>Coldplay<cd>X&Y" +
"<recording><artist>Dave Matthews<cd>Under the Table and Dreaming" +
"<recording><artist>Dave Matthews<cd>Live at Red Rocks" +
"<recording><artist>Natalie Merchant<cd>Tigerlily" +
"<recording><artist>U2<cd>How to Dismantle an Atomic Bomb" +
"";

// Read the xml.
StringReader reader = new StringReader(musicXml);
set1.ReadXml(reader);

// Get a DataView of the table contained in the dataset.
DataTableCollection tables = set1.Tables;
DataView view1 = new DataView(tables[0]);

// Create a DataGridView control and add it to the form.
DataGridView datagridview1 = new DataGridView();
datagridview1.AutoGenerateColumns = true;
this.Controls.Add(datagridview1);

// Create a BindingSource and set its DataSource property to
// the DataView.
BindingSource source1 = new BindingSource();
source1.DataSource = view1;

// Set the data source for the DataGridView.
datagridview1.DataSource = source1;

source1.Filter = "artist = 'Dave Matthews'";
}

Regards,
Lev

Assuming the 1000 rows are coming from a data base, you have two options...

1) Query only the data your looking for and not everything, remember "any monkey can SELECT * FROM

2) Use a DataView to filter out the data you want to display

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111

as mentioned use the filter option or change the query to have a where clause.
but FYI. THE USE OF CAPITALS is considered shouting in forums. Big Grin | :-D

V.

Stop smoking so you can: Enjoy longer the money you save.
Moviereview Archive