C# Discussion Boards - CodeProject

First Prev Next

Re: SourceGrid customise

Henry Minute11-Aug-09 4:52

Henry Minute

11-Aug-09 4:52

You are likely to get a better answer on their page here[^]

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.”

Re: SourceGrid customise

Parth Gandhi18-Aug-09 2:04

Parth Gandhi

18-Aug-09 2:04

Is it possible to add tree control in sourcegrid column?//

-- pgandhi

Re: SourceGrid customise

Henry Minute18-Aug-09 2:15

Henry Minute

18-Aug-09 2:15

As before. Ask on the site of the maker of the control.

Update SQL Server 2005 table with DataGrid contents

Wheels01211-Aug-09 3:35

Wheels012

11-Aug-09 3:35

Good morning.

I have populated a DataGridView with a dataset from a query off a table in SQL Server 2005. Now when a user makes changes in the DataGridView and clicks on a 'Save' button, I want the dataset to be updated and the table to reflect the changes. The datagrid is on a form and all the queries are called from the DAL.

My code is as follows:

private void btnQuery_Click_1(object sender, EventArgs e) 
{ 
PwdSecurity p = new PwdSecurity(); 
uipc = this.Parent as UIPCMainForm; 
const string constrallowedBlockTypes = "allowedBlockTypes"; 
DAL d = new DAL(uipc.StrUserName, p.base64Decode(uipc.StrPassword)); 

DataSet ds = new DataSet(); 
ds = d.AllowedTypes(constrallowedBlockTypes); // Returns dataset correctly from method in DAL 

//New code 
BindingSource bs = new BindingSource(); 
bs.DataSource = ds; 
bs.DataMember = ds.Tables[0].TableName; 
dgv.DataSource = bs; 

// End new code 
} 

DAL: 

myConnection = 
new SqlConnection("server=PTLLBNB0DD1\\SQLSERVER2005;database=IPControl;Trusted_Connection=yes"); 

public DataSet AllowedTypes(string Type) 
{ 
string SQL = String.Empty; 
ds = new DataSet(); 
try 
{ 
SqlCmd = new SqlCommand("spGET_ALLOWED_TYPE", myConnection); 
SqlCmd.CommandType = CommandType.StoredProcedure; 
SqlCmd.Parameters.Add("@Type", SqlDbType.VarChar, 50); 
SqlCmd.Parameters["@Type"].Value = constrallowedDeviceTypes; 

if (myConnection != null) { myConnection.Close(); } 

myConnection.Open(); 
SqlAdapt = new SqlDataAdapter(SqlCmd); 
SqlAdapt.Fill(ds); 
} 
catch (Exception e) 
{ 
MessageBox.Show("DAL Layer / AllowedTypes method error. \n\r \n\r" + 
e.Message.ToString() + " \n\r \n\r" + SQL); 
} 
finally 
{ 
if (con != null) { con.Close(); } 
if (aCommand != null) { aCommand.Dispose(); } 
if (adapter != null) { adapter.Dispose(); } 
} 

return ds; 
}

If I had access to the SqlAdapt, I could probably use SqlAdapt.Update(ds), but i don't currently.

Any suggestions?

WHEELS

I want to load a button in the title bar

flydk11-Aug-09 3:28

flydk

11-Aug-09 3:28

I want to load a button in the title bar through C# . Confused | :confused:

like this http://img2.pconline.com.cn/pconline/0808/01/1371600_3.gif[^]

thanks^_^

Re: I want to load a button in the title bar

Saksida Bojan11-Aug-09 4:23

Saksida Bojan

11-Aug-09 4:23

Please clerify. That picture doesn't have any connection to your question and i don't understand the writing

Re: I want to load a button in the title bar

flydk11-Aug-09 14:41

flydk

11-Aug-09 14:41

I'm very sorry.my english is very poor.
I want to add a button in the title bar.

this is a new image:
http://i.namipan.com/files/b8960a971f65908aaa18bd5dec30a00c5c529a71370b00007502/0/1.jpg[^]

Re: I want to load a button in the title bar

Saksida Bojan12-Aug-09 8:19

Saksida Bojan

12-Aug-09 8:19

There is no easy whay.
You need to override some events. Here is some discusion on costum draw title bar

http://bytes.com/topic/c-sharp/answers/278991-any-way-custom-draw-title-bar[^]

I am sorry that i didn't read your first post clearly. Even my english is not first language and can be poor. I Have mistaken for Title Bar for Taskbar and then asked for cleryficiation.

Re: I want to load a button in the title bar

flydk12-Aug-09 19:09

flydk

12-Aug-09 19:09

I konw this method,but that ont isn't what I want.and thank you advance.
I will look for a new method to deal with this question.
你懂汉语吗？

Replace(@"\\", @"\") not working

dptalt11-Aug-09 3:22

dptalt

11-Aug-09 3:22

I want to replace the double backslash with a single backslash. The following code does not work.

pResult.Path = pResult.Path.Replace(@"\\", @"\");

It does not do any replacement at all. How can this be accomplished?

Re: Replace(@"\\", @"\") not working

Andrew Rissing11-Aug-09 3:58

Andrew Rissing

11-Aug-09 3:58

That should work as is. If you're looking at it in the watch window, be mindful that Visual Studio already escapes special characters with a slash. If you click on the magnifying glass (the visualizer), you should be able to see the 'unescaped' version of the string.

Re: Replace(@"\\", @"\") not working

dptalt11-Aug-09 4:04

dptalt

11-Aug-09 4:04

You are right, it did work. Thanks for the clarification.

how to get data from the tags of a TIFF image

gilvani11-Aug-09 3:05

gilvani

11-Aug-09 3:05

Getting the data from the tags of a TIFF image
I'm trying to make a program that opens a TIFF image and puts the data from the tags in texboxs but I do not know how to extract the data. If anyone knows how can help me.
thanks D'Oh! | :doh:

Re: how to get data from the tags of a TIFF image

Luc Pattyn11-Aug-09 3:21

Luc Pattyn

11-Aug-09 3:21

Hi,

here is some code I've been using for that purpose, it was aiming at JPEG though:

	FileStream stream=new FileStream(fileSpec, FileMode.Open, FileAccess.Read);
	//File.OpenRead(fileSpec);
	Image localImage2=Image.FromStream(stream);
#if true
	int[] piList=localImage2.PropertyIdList;
	Dictionary<int, string> propNames=new Dictionary<int,string>();
	propNames.Add(0x010E, "ImageDescription");
	propNames.Add(0x010F, "EquipMake");
	propNames.Add(0x0110, "EquipModel");
	propNames.Add(0x0112, "Orientation");
	propNames.Add(0x011A, "XResolution");
	propNames.Add(0x011B, "YResolution");
	propNames.Add(0x0132, "DateTime");
	propNames.Add(0x0128, "ResolutionUnit");
	propNames.Add(0x0131, "SoftwareUsed");
	propNames.Add(0x0201, "JPEGInterFormat");
	propNames.Add(0x0202, "JPEGInterLength");
	propNames.Add(0x0213, "YCbCrPositioning");
	propNames.Add(0x501B, "ThumbnailData");
	propNames.Add(0x502D, "ThumbnailResolutionX");
	propNames.Add(0x502E, "ThumbnailResolutionY");
	propNames.Add(0x5090, "LuminanceTable");
	propNames.Add(0x5091, "ChrominanceTable");
	propNames.Add(0x829A, "ExifExposureTime");
	propNames.Add(0x9003, "ExifDTOrig");
	propNames.Add(0x9004, "ExifDTDigitized");
	propNames.Add(0x9204, "ExifExposureBias");
	propNames.Add(0x9209, "ExifFlash");
	propNames.Add(0x927C, "ExifMakerNote");
	propNames.Add(0x9286, "ExifUserComment");
	propNames.Add(0xA002, "ExifPixXDim");
	propNames.Add(0xA003, "ExifPixYDim");
	foreach (int ID in piList) {
		//if (propNames[ID]==null) getPropertyItem(localImage2, ID, propNames);
		if (propNames.ContainsKey(ID)) getPropertyItem(localImage2, ID, propNames);
	}
#endif
	// we now create a copy, so we can close the filestream
	// MSDN says: You must keep the stream open for the lifetime of the Image object.
	// see also the article "PRB: Image File Is Locked When You Set the PictureBox
	// Image Property to a File"
	localImage=new Bitmap(localImage2);
	stream.Close();
	localImage2.Dispose();

and

protected void getPropertyItem(Image image, int ID, Dictionary<int, string> propNames) {
	string s=(string)propNames[ID];
	if (s==null) s="";
	s+=new string(' ', 20);
	s=s.Substring(0, 20);
	string name="Prop"+LP_Format.Hex4(ID)+" "+s;
	string type=null;
	try {
		PropertyItem pi=image.GetPropertyItem(ID);
		s="";
		byte[] bb=pi.Value;
		switch ((PropertyTagType)pi.Type) {
			case PropertyTagType.Byte: 
				type="(byte)";
				for (int i=0; i<bb.Length; i++) {
					byte us=bb[i];
					s+=" "+us.ToString("X2");
					if (bb.Length==1) s+="("+us.ToString()+")";
				}
				break;
			case PropertyTagType.ASCII:
				type="(ASCII)";
				s=" "+ASCIIencoding.GetString(pi.Value, 0, pi.Len-1);
				break;
			case PropertyTagType.Short:
				type="(short)";
				for (int i=0; i<bb.Length/2; i++) {
					ushort us=BitConverter.ToUInt16(bb,2*i);
					s+=" "+us.ToString("X4");
					if (bb.Length==2) s+="("+us.ToString()+")";
				}
				break;
			case PropertyTagType.Long :
				type="(long)";
				for (int i=0; i<bb.Length/4; i++) {
					ulong us=BitConverter.ToUInt32(bb,4*i);
					s+=" "+us.ToString("X8");
					if (bb.Length==4) s+="("+us.ToString()+")";
				}
				break;
			case PropertyTagType.Rational:
				type="(rational)";
				for (int i=0; i<bb.Length/8; i++) {
					uint uNominator=BitConverter.ToUInt32(bb, 8*i);
					uint uDenominator=BitConverter.ToUInt32(bb, 8*i+4);
					s+=" "+uNominator.ToString()+"/"+uDenominator.ToString();
				}
				break;
			case PropertyTagType.Undefined:
				type="(undefined)";
				for(int i=0; i<bb.Length; i++) {
					s+=" "+bb[i].ToString("X2");
				}
				break;
			case PropertyTagType.SRational:
				type="(srational)";
				for (int i=0; i<bb.Length/8; i++) {
					int uNominator=BitConverter.ToInt32(bb, 8*i);
					int uDenominator=BitConverter.ToInt32(bb, 8*i+4);
					s+=" "+uNominator.ToString()+"/"+uDenominator.ToString();
				}
				break;
		}
		if (type==null) type="?"+pi.Type+"?";
		env.log(0, name+LP_String.Extend(type, 12)+s);
	} catch (Exception exc) {
		env.log(0, "Unable to obtain "+name+"; "+exc.Message);
	}
}

Hope this helps.

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

How to apply RowFilter for a String Date

Sreedhar Kadiyala11-Aug-09 3:02

Sreedhar Kadiyala

11-Aug-09 3:02

Hi,

I'd a DataTable where I'd filled the data using SQL Statement "SELECT CONVERT(VARCHAR,DOB,105) AS DOB FROM TABLENAME".

Here the DataTable is filled with Dates by using the format "dd-MM-yyyy"

My problem is I need to apply the Filter viz., =, >, >=, <, <= on the DataTable based on the input given by the user in the same format "dd-MM-yyyy" irrespective of the datetime setting in the user system.

Can any one suggest on this.

Thanks in Advance

Sreedhar Kadiyala

Re: How to apply RowFilter for a String Date

dptalt11-Aug-09 3:49

dptalt

11-Aug-09 3:49

In your select statement include a where clause the would be a built string based on the input the user entered. For example:

"WHERE mydate < CONVERT(DATETIME, '" + "07/01/2009" + "00:00:00', 103)"

Replace 07/01/2009 with logic that would build that part of the string based on the user inputs.

Re: How to apply RowFilter for a String Date

Anjups7-Sep-09 20:40

Anjups

7-Sep-09 20:40

Hi,

Take the input from the user which would be in the form of '=, >, >=, <, <=' and the string with this try to make a filter condition and apply it to the rowFilter of the dataview.You will surely get..

Regards
Anju

DateTime.TryParseExact() problem?

Henk Meijerink11-Aug-09 2:46

Henk Meijerink

11-Aug-09 2:46

Hi,

I can't see what's wrong with this code. I am getting "1/2/2009 9:00:00 AM" displayed in the textBox when I'm expecting "1/2/2009 9:00:00 PM". Can anyone tell me what I'm doing wrong here, please?

DateTime dateTime;
DateTime.TryParseExact("1/2/2009 9:00 PM", "d/M/yyyy H:m tt", CultureInfo.InvariantCulture, DateTimeStyles.None, out dateTime);
textBox1.Text = dateTime.ToString();

I'm using VS2008 and targeting .NET 3.5 and have "en-AU" as the default Windows culture.

Thanks, Henk.

Re: DateTime.TryParseExact() problem?

stancrm11-Aug-09 2:57

stancrm

11-Aug-09 2:57

DateTime.TryParseExact("1/2/2009 9:00 PM", "g", CultureInfo.GetCultureInfo("en-US"), DateTimeStyles.None, out dateTime);

See MSDN:
http://msdn.microsoft.com/en-us/library/ms131044.aspx[^]

Re: DateTime.TryParseExact() problem?

Henk Meijerink11-Aug-09 3:45

Henk Meijerink

11-Aug-09 3:45

Thanks stancrm, I was reading up on the "g" you used and that led me to Custom Format Strings at http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx[^] where I realised I should be using h instead of H if I'm wanting to parse the AM/PM part. Thanks for assisting. Regards, Henk.

Updated:Filter for DataGridView [modified]

janadhana11-Aug-09 2:14

janadhana

11-Aug-09 2:14

Hi,
Please let me know how to add a filter for DataGridView so that the user can enter the filter condition in the corresponding column header to filter the rows that match the condition.

I am new to C#. Requirement is simillar to how it is in Mercury Quality center or TestDirector tools.

Hope the question is clear..

Thanks & Regards,
Dhana

modified on Tuesday, August 11, 2009 8:29 AM

Re: Updated:Filter for DataGridView

Sreedhar Kadiyala11-Aug-09 2:49

Sreedhar Kadiyala

11-Aug-09 2:49

Hi,

Since the DataTable source is assigned to DataGridView, you can filter the DataTable by using
DataTable.DefaultView.RowFilter="ColName=" + ColValue
It will automatically apply to the DataGridView

Sreedhar

Re: Updated:Filter for DataGridView

janadhana11-Aug-09 19:36

janadhana

11-Aug-09 19:36

Thanks very much..i am now using the simillar code for implementing the filter.

Thanks & Regards,
Dhana

Re: Updated:Filter for DataGridView

dan!sh 11-Aug-09 2:58

dan!sh

11-Aug-09 2:58

If this is a bound DataGridView, you are not allowed to add rows. Hence you will need to extend the DataGridView if you need a filter like Quality center.

A quick and dirty (and may be "not recommended") way is:
1. Provide padding the headercell.
2. Add a textbox to the DataGridView at the location right above the first row.(You will need to play with the location of the textbox)
3. Handle its TextChanged event and set the RowFilter property of the datatable you have.

A better solution IMO will be to have a button and display a modal window where in user can apply filter.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

Re: Updated:Filter for DataGridView

janadhana11-Aug-09 19:37

janadhana

11-Aug-09 19:37

Thanks very much..I have followed the steps that you have given and created it..as you said it is ugly..it seems the same to me..I am trying to make it more clean.

Thanks & Regards,
Dhana

Last Visit: 31-Dec-99 18:00 Last Update: 2-Jun-24 20:36

Refresh

ᐊ Prev 1...4551 4552 4553 455445554556 4557 4558 4559 4560 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.