Search form dynamic sql

Windows Forms Data Controls and Databinding

- Previous
  - 1
    - DataGridView vs 3rd Party Grids Im moving a vb6 application over to .NET 2.0. The app currently relies a third party grid control, iGrid by 10Tech. I would like to use a DataGridView to replace the third party grid, but Im having trouble convincing the other developer Im working with. He would like to use iGrid.NET, the .NET version of the 10Tech iGrid. Which way to go How do we decide which is better I sure that anything we can do with the iGrid we can also do with the DataGridView. My problem with using the iGrid is the lack of support and documentation. The DataGridView is well supported, well documented, and there is plenty of stuff on the web about it. Anyone care to share arguments for or against DataGridView Arguments For or against third party grids Your help is appreciated, thanks. Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 2
    - MDI: getting form handle affects child focus Hello: I have a MDI and multiple child forms. The only way to bring a child in focus and to the front of the other forms is by clicking on the titlebar. I have discoverd that this occurs only when I set a property on the form to the form's handle in the new() sub. It does not happen if I do this in the load event Why does this happen. here is the code for the child Public Sub New ( ByVal pParentID As Int64, ByVal pAppRule As Int32) ' InitializeComponent() ' Add any initialization after the InitializeComponent() call. FormID = Me .Handle ParentID = pParentID ApplicationRule = pAppRule End Sub Thanks for any help on this. smhaig Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 3
    - Editing in Datagridview! Wadup! I have a GUI with a datagridview . The user can select some data (out of an integrated table) and the selected data from this table will be automatically written into a row of the Datagridview. Now that the data has been entered in the datagridview row, i want to implement a feature in which the user can manually go to row( with a mouse click for example) and make some changes in the data (for example change age=23 to age =24) which was automatically transferred from the table based on user selection. so basically i want to implement edit functionality for a datagridview row on a mouse click event after some data has been entered in the row. Ho do i do it Cheers! Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 4
    - panel layout Hi, I have a panel in my windows form application that has six buttons in a single row. I want to layout the buttons so that when the window is resized they fill out (shrink and grow) at the same rate. Is there a way I can do this Thanks, Wallace Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 5
    - Step by step instruction. Open Form2 from Button on form1 C# Hi, anyone able to tell me please how to.. Click on a Button i named Next on Form1.. it will then open Form2 page not as an extra page.. but as though its a new page on the same window. ty Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 6
    - filling a datagridview from a stored proceduer I am trying to fill a datagridview from a SP but it is not working Private Sub buildXLS( ByVal vennum As String ) Dim objconn As New SqlConnection(connstring) Dim ocomm As New SqlCommand ocomm.Parameters.Add( New System.Data.SqlClient.SqlParameter( "@vendornum " , System.Data.SqlDbType.Text, 15, "vennum" )) ocomm.Parameters( "@vendornum " ).Value = vennum ocomm.Connection = objconn ocomm.CommandType = CommandType.StoredProcedure ocomm.CommandText = "sp_forcastBeverly" objconn.Open() ocomm.ExecuteNonQuery() Dim da As SqlDataAdapter = New SqlDataAdapter da.SelectCommand = ocomm Dim ds As DataSet = New DataSet da.Fill(ds) DataGridView1.DataSource = ds objconn.Close() end sub I also tried Dim sqlconnection As New SqlConnection(connstring) Dim sqlcommand As New SqlCommand( "sp_forcastBeverly" , sqlconnection) sqlcommand.CommandType = CommandType.StoredProcedure sqlcommand.Parameters.AddWithValue( "@vendornum" , Trim(vennum)) sqlconnection.Open() DataGridView1.DataSource = sqlcommand.ExecuteReader sqlconnection.Close() sqlcommand.Dispose() Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 7
    - get linq results This is the situation: When I load my app, I want to get some data from the database with LINQ and bind it to a datagridview. If the sql server is down, the app would be invisible for 15 seconds while the query is running (query executed in FormLoad), in order to avoid that I am using a backgroundworker. (which I start from the FormLoad event). So currently my backgroundworker contains the following code: try { DataClassesHQDataContext context = new DataClassesHQDataContext (); var q = from ag in context.ArticleGroups select ag; this .Invoke(( MethodInvoker ) delegate { this .dataGridViewAG.DataSource = q; }); } catch ( SqlException se) { MessageBox .Show( "aaa" ); } What I am trying to achieve is: 1) get the data while showing the form and also not blocking the UI 2) handle exceptions related to getting data -> SqlException The problem I am having is this: Currently the catch block does not catch anything, because (I think) I'm invoking stuff on another thread. Also I'm guessing that I am currently still blocking the UI thread, beacause of the this.Invoke stuff. That is why I don't want to put the try-catch within the anonymous method either... The ideal solution to my problem would be this: 1) Instead of the this.Invoke(...) line I write something like <SomeObject> obj = q; this.BackgroundWorker.ReportProgress(50, obj); 2) Then I could handle the ReportProgress event and databind the results, using the object obj. At the moment I have no ideas how to run the linq query and get the results into an object ("obj") which I could then use. As far as I know, passing q into ReportProgress() doesn't help because the query is executed when it is first used (either when databinding, or in a foreach statement, or stuff like that) meaning I would still block the UI while getting the data, but I haven't tested this yet... Anyone have any ideas or any other solutions PS! I'm using VS2008 Beta2 with .Net 3.5 Beta 2 Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 8
    - IDs not refreshed when new rows are added to Datagridview Hi, I'm a newbie for .Net. I have a datagridview which is populated by a datatable. (Note: I fill this datatable by passing this datatable as a reference to another project that uses a dataadapter and dataset and return values in this datatable) The grid is populated and when the user clicks on the "Add" button then I programttically create a datarow and put the focus on the newly created cell in the datagridview. When the user either moves to the next row or hits the "Save" button then this datatable with the new values is sent (byref) to the project that fetched data to be saved back to the db (using the dataadapter.update). It works fine in saving it to the db, but the new id is not refreshed in the datatable. Any help would be appreciated. Thanks, SS Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 9
    - Asynchronous calling question Hi, I have a method that calculates directory size recursively. With large directory structures it is quite slow so I decided to start it on a separate thread so I could use my form meanwhile. I read a lot about threading but something is not clear. Here is my code: Code Snippet delegate long MyDirSizeDelegate(DirectoryInfo di); ... DirectoryInfo di=new DirectoryInfo(dir); MyDirSizeDelegate mdsd = DirSize; IAsyncResult res; res = mdsd.BeginInvoke(di, null, null); long size=0; while (!res.IsCompleted) { Thread.Sleep(100); } size = mdsd.EndInvoke(res); "We then call BeginInvoke. This begins execution while immediately returning control to the caller" as I read. I used Backgroundworker and it worked like dream when Thread.Sleep was called. How can I have the same here My form is frozen while the method is running. I could use BGW, but I decided to test this. I hope, I didn't do any lame thing. Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 10
    - Populating DataGridView in Rows and Columns from DataSet Hi, I have a previous thread at http://forums.microsoft.com/msdn/showpost.aspx postid=1467164&SiteID=1 and had a further question on the subject. I have developed the following based on the previous post. Note that I have another datatable dtPeopleRatings which contains PeopleID and SkillCodeID. I loop through this datatable and add a row to the dgv for each peopleid and fill the checkboxes horizontally for the SkillCodeID. Because the tblSkills table does not have an orderly RoleID, I could not check the box by doing: Code Snippet //check box ticked dr[RoleID-1] = true; I needed some way to set the ID of the columns in the datagridview, so that I know which column to check. So ended up looping through the columns to find the column with the Caption of RoleID. Code Snippet //loop through the columns to find the column with the Caption of RoleID for (int k = 0; k < dtRole.Rows.Count; k++) I was wondering whether there was a more efficient way to achieve the following Also if the dataGridView changes, I want to be able to write back the the original table in the database (tblPeopleRoles). I assume that dtSource is being updated, so I need to be able to update dtPeopleRatings too.I can put this on a new thread if desired. Code Snippet private void DgvCrossCheckBox_Load(object sender, EventArgs e) { String strCon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\abc.mdb"; //get People data String strSQL = "select * from tblPeople"; OleDbDataAdapter dataAdapter = new OleDbDataAdapter(strSQL, strCon); DataTable dtPeople = new DataTable("People"); dataAdapter.Fill(dtPeople); //get people ratings data strSQL = "select * from tblPeopleRatings"; dataPeopleAdapter = new OleDbDataAdapter(strSQL, strCon); dtPeopleRatings = new DataTable("PeopleRatings"); dataPeopleAdapter.Fill(dtPeopleRatings); //get skill data strSQL = "select * from tblSkills"; dataAdapter = new OleDbDataAdapter(strSQL, strCon); DataTable dtRole = new DataTable("Skills"); dataAdapter.Fill(dtRole); //set up datatable to be used on datagridview dtSource = new DataTable(); DataColumn dtColumn=null; for (int j = 0; j < dtRole.Rows.Count; j++) { //set the column names dtColumn= dtSource.Columns.Add(); dtColumn.DataType = System.Type.GetType("System.Boolean"); //hidden caption = id of column to be searched on dtColumn.Caption = dtRole.Rows[j]["SkillCodeID"].ToString(); // displayed heading name dtColumn.ColumnName = dtRole.Rows[j]["Skill_Name"].ToString(); } for (int i = 0; i < dtPeople.Rows.Count; i++) { //people id of base table double PeopleID = (double)dtPeople.Rows[i]["PeopleID"]; //new row for each person DataRow dr = dtSource.NewRow(); for (int j = 0; j < dtPeopleRatings.Rows.Count; j++) { //peopleid of joined table double PeopleID2 = (double)dtPeopleRatings.Rows[j]["PeopleID"]; //match people id if (PeopleID == PeopleID2) { //role id of joined table double RoleID = (double)dtPeopleRatings.Rows[j]["SkillCodeID"]; bool foundColumn = false; //loop through the columns to find the column with the ColumnName of RoleID for (int k = 0; k < dtRole.Rows.Count; k++) { if (dtSource.Columns[k].Caption == RoleID.ToString()) { //check box ticked dr[k] = true; foundColumn = true; } if (foundColumn) break; } } } //add the new for each person dtSource.Rows.Add(dr); } //bind the dgv to the data source this.dataGridView1.DataSource = dtSource; for (int i = 0; i < dtPeople.Rows.Count; i++) { //add row header this.dataGridView1.Rows[i].HeaderCell.Value = dtPeople.Rows[i]["Name"]; } //auto size columns this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; this.dataGridView1.AutoResizeRowHeadersWidth( DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders); // Set the DataGridView control's border. dataGridView1.BorderStyle = BorderStyle.Fixed3D; this.dataGridView1.CurrentCellDirtyStateChanged += new EventHandler(dataGridView1_CurrentCellDirtyStateChanged); this.dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellValueChanged); } Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 11
    - Modifying BidingSource I wonder if I can modify the bindingsource to dispaly specific field from a table rather than displaying the whole table. Here is what I am talking about. I am using a commercial grid to display my data. I don't have any problem to display the whole table to the grid. For instance, the following code displays a whole table to the grid. grid1.SetDataBinding(table1BindingSource); Now, I only want to display the FirstName and the LastName I have the following in my form table1BindingSource and db1DataSet From db1DataSet, I can see the following by intellicense; my table names Tabl1 from intellicense I can see Table1.FirstNameColumn and Table1.LastNameColumn; My question, how can I use table1BindingSource and db1DataSet to display only the firstname and the lastname rather than the whole table Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 12
    - "Enter" button focus All they taught in college was Java. Now that I've gradutated and have the time I've been having some really big fun with Visual Studio 2005 Pro :-) Question: Using the above IDE, I want to give an "Enter" button focus whenever the keyboard "Enter" key is pressed regardless of what control has focus. This is for a Windows Application. I tried setting the Form property "AcceptButton" to the "Enter" button in question and setting the "KeyPreview" property to true but it didn't work. Any help would be greatly appreciated! BTW - I looked a the VS forums but none looked like they were designed for this sort of question. If there is one please point me in that direction. Thanks Pat Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 13
    - cancel navigator add new on double add -using no null allowed exception hi how can i cancel when the add button is pressed twice, i get no null allowed Public Class Navigator Inherits BindingNavigator Private Sub BindingNavigatorAddNewItem_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles BindingNavigatorAddNewItem.Click If BindingSource IsNot Nothing Then Try BindingSource.AddNew() Catch r As NoNullAllowedException MsgBox( "Please finish edit the current new row first." ) End Try End If End Sub Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 14
    - pagesetupdialog How do use page setup dialog in visual c# Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 15
    - Validatechildren does not fire the validate event I have a toolstrip with a save button and 2 textboxes on my form. When I click on the save button, i'm calling validatechildren. I would expect the validating event to be fired for all children (in this case both textboxes), however the validating event does not fire on the textbox that has focus. How can I get the validating event to fire for all children, even the one that has focus Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 16
    - Bind ArrayList with object member to DataGridView I wish to bind an ArrayList of data objects to a DataGridView. If the ArrayList contains objects of simple types no problem the grid is populated as expected with public property names. However, if the objects of the ArrayList themselvescontain an object member, the object is representing in the grid by a single 'object' column. How do I implement Databinding to expand the member objects such as the "employee" objects shown below BindingSource bs = new BindingSource (data, "Teams" ); this .dataGridView1.DataSource = null ; this .dataGridView1.DataSource = bs; this .dataGridView1.Refresh(); class Team { private Employee leader; private Employee runt; private string name; //Public Properties } class Employee { private string name; private string id; //Public Properties } As a newbie a code example would be greatly appreciated. Thank you. Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
- Next
  - 1
    - Binding a textbox to the main Data Connection I would like a user to be able to go into a configuration or be prompted at startup to enter a server name and the entire application and data sources are now using that server. I don't want the user to have to go into anything advanced to make this change. For example, my current server is KRIS\SQLEXPRESS in the server explorer and my data sources point to this one server to retrieve and store data. I would like this to be changed at the client application level so that the user can type something like SERVER123\SQLEXPRESS and then all data sources are now pointing to the new server. I guess I might need the user to have access to the Data Connection wizard or something, and then change the property of the Data Source. I am somewhat new to this so any help is greatly appreciated. I am using VB on VS2005. Thank you, Kris Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 2
    - date & time difference I have two DateTimePickers (dateFrom and dateTo).. I want to get the difference in words.. for example, two days, eight hours, twenty two minutes Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 3
    - Password change logic. Hello, I have windows form as given below. ___________________ Old Password : [__________________] {name:txtOldPasswd} New Password : [__________________] {name:txtNewPasswd} Confirm Password : [__________________] {name:txtNewCPasswd} User shud be able to change their passwrod. Few things i need to check when user clcik on apply button are. 1>Old apssword is correct 2>new password and confirm password is same. Even case is same. 3>New password and confirm password cannot be blank. 4>old and new password cannot be same 5>if one textbox has some value then all 3 should have some values. fir this my logic is: //mad is a object which has password1 as a property. if (mad.Password1 != txtOldPasswd.Text || txtOldPasswd.Text="") { MessageBox.Show("your old password is wrong"); bResult=false; break; } if (txtNewPasswd.Text == txtNewCPasswd.Text) { txtOldPasswd.Text = txtNewPasswd.Text; mad.UserID = mad.UserID; mad.Password1 = txtNewPasswd.Text; } else { MessageBox.Show("your new password and confirm password does not match"); bResult = false; } } i know there should be a cleaner way to do this. Please let me know. Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 4
    - DataGridView Gridlines Hi, I have in most of the situations DataGridViews that have less records than the DataGridView height is. Therefore half of the grid is empty whereas the other half has gridlines. Is there any posibility to display grid lines in all "rows", but not by adding empty rows to the DataSource Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 5
    - WebBrowser.Navigate IE7 pdf adobe not run in same window On some machine I found that when I call WebBrowser _wb = new WebBrowser (); _wb.Navigate( "C:\\temp\\test.pdf" , true ); IE7 will not run the adobe viewer in same window, but if I open up IE7 and type c:\temp\test.pdf IE7 will display the pdf in same window. Does anybody have a suggestion to why IE7 has behaviour when invoke using WebBrowser.Navigate Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 6
    - How to save data in a datagridview to a database? In a Windows form I have a "Save" button to save the rows of data from a Datgridview control to a database. The following is the code attached to the "Save" button with the "Click" event and it did not work. Help! Dim ctl As New Datagridview ctl = Me.dgv_Sales_Details Dim r As Intefer = 0 For r = 0 To ctl.RowCount - 1 If r <> ctl.CurrentCell.RowIndex Then Dim StockNumber As String = ctl.Item(1, r).Value.ToString Dim StockNumber As String = ctl.Item(1, r).Value.ToString Dim StockNumber As String = ctl.Item(1, r).Value.ToString AddSalesDetails(CInt(Me.txt_Invoice_Number.Text), StockNumber, Product, CommonName) End If Next Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 7
    - Deployment of .NET 2.0 framework? How do I force my deployment setup to NOT look at the internet for .NET 2.0 framework (this is NOT a click once deployment). There appear to be 2 locations where I specify where my app should get .NET 2.0 framework from. 1 - right click on my Deployment Project that is part of my solution select Properties, under configuration properties select "Build", click on Prerequistes, have .NET framework 2.0 checked and have "download prerequisites from the same location as my application" 2 - in the Deployment Project their is a Launch condition added called .NET Framework with an InstallUrl property that is set to http://go.microsoft.com/fwlink/ LinkId=9832 Should InstallURL be left blank or should it point to a relative local path such as ../dotnetfx to avoid it checking the internet at the link above If relative path, could I get a syntax example Thanks, Rob. Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 8
    - Slow form loading time Hi all I have a real problem. I have made an app where each form has a jpeg image as it's background. When i run the app all the forms take a while to load the controls on them. At first i thought it was because i have too many controls and containers but i tried it again with just two textboxes and a button and its the same thing. Bottom line is as long as i have the jpeg as the form background the controls on the form take a couple of extra seconds to load which is highly irritating. I have tested this app in Vista,XP and Win 2000 and it seems to happen most in Vista and less in Win 2000. Im using adobe fireworks 8 to create the jpegs. I dont want to change the picture format because i will be sacrificing pic quality. Does anyone have a solution to this problem. I need help urgently.Thanks in advance. Matt Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 9
    - Corrupt Form - Designer cannot open : help Running Visual Studio 2005 using VB. Form was working fine, was in the process of debugging etc. Opened some other modules made changes. Went back to open my form and got the following Error I saw a few other threads of corrupted forms after upgrades etc but didn't seen anything quite like this. Anyone have any ideas Thanks in advance Mike One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index Hide at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value) at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeAssignStatement(IDesignerSerializationManager manager, CodeAssignStatement statement) at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeStatement(IDesignerSerializationManager manager, CodeStatement statement) Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 10
    - Grouping Question?? Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 11
    - READ .INI FILE ROWES AND PASS IT TO LISTVIEW? Hi i need to pass .ini text in row 5, charachters 10-15. is it passible I know there��s a sub folder in this path with an .ini file. And i need to pass that info, into my listview. And how do i change the dirictory to only look in sub folder in this path string [] lines = System.IO. File .ReadAllLines( @"data.txt" ); string appl = lines[1]; string path = lines[2]; string sort = lines[5]; System.IO. DirectoryInfo dir = new System.IO. DirectoryInfo (path); FileInfo [] fi = dir.GetFiles(); foreach ( FileInfo file in fi) { int filesCouunt = dir.GetFiles().Length; string name = dir.Name; DateTime time = DateTime .Now; ListViewItem item = new ListViewItem ( new string [] { sort, name, time.ToString(), "inget" , filesCouunt.ToString() + " st" , "inget" , appl }); this .listView2.Items.Add(item); this .listView2.AutoResizeColumns( ColumnHeaderAutoResizeStyle .HeaderSize); } Would help me allot... I��m stuck..! tnx Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 12
    - Faster way to display thumbnails in Windows Forms with C# Where is the forum to request a faster way to display thumbnails in a ListView in a Windows Form (using C#) Thanks! Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 13
    - SQL Express Backup I am trying to create a WinApp that allows the user to select a database to backup. I want a "Save As" Dialog to appear, and when they click the save button the database backup is performed and is saved into the location they selected. I am a little confused on how to do that. Here is what I have now. if (saveBackupDialog.ShowDialog() == DialogResult .OK) { Backup bu = new Backup (); bu.Action = BackupActionType .Database; bu.BackupSetName = fileBackup; bu.Database = "Test" ; //database name bu.Initialize = true ; BackupDeviceItem bdi = new BackupDeviceItem (saveBackupDialog.FileName, DeviceType .File); bu.Devices.Add(bdi); Server server = new Server ( ".\\SQLEXPRESS" ); //server try { bu.SqlBackup(server); } catch ( Exception x) { } } If I save to "C:\Doug" it works, if i try "C:\Documents and Settings\Doug\Desktop" it does not work. Even if I do "C:\Documents and Settings" it wont work. I am stumped as to why this wont work. Any suggestions are appreciated. Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 14
    - Can not bind the visible property of controls to class Hi Just trying to bind the "Visible" property of a windows label control to my class. No luck. The control is always invisible no matter the bool type property of my object is true or false. Tried "Enabled" property of the control and it's work great. Any idea Thanks Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 15
    - Invalidate and CPU Usage Hi all I have created User control in WinForm C# ( RT) application and located it on a form. I had needed to repaint the control every 10 sec and I did it by using a timer and in the Tick event I useed the Invalidate() method of the control. It works good in the beginning but after sometime the peaks of the CPU usage at the time of repainting the control are becoming bigger and bigger till it reaches the 100% and the application get stuck . Can someone can tell me why and what is the resolution to this problem Thanks Assaf Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms
  - 16
    - I have some Problem ProcessCmdKey? Hi ! My form has Function //// /// /// protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { if (msg.WParam.ToInt32() == (int)Keys.Enter)|| (msg.WParam.ToInt32() == (int)Keys.Down) { SendKeys.Send("{Tab}"); } if (msg.WParam.ToInt32() == (int)Keys.Up) { SendKeys.Send("+{Tab}"); } return base.ProcessCmdKey(ref msg, keyData); } } My Grid has Function too // // // protected override bool ProcessCmdKey(ref Message msg, Keys keyData) { if (msg.WParam.ToInt32() == 13) { SendKeys.Send("{Tab}"); return true; } } When i am using Key Up / Key Down in Grid then control move Diagonal Tag: Windows Forms Data Controls and Databinding Search form dynamic sql Windows Forms

erzfezsf

hello

i am trying to implement a multiple criteria search form, so far I have written the stored procedure which contains the dynamic sql.

I have a windows form with some search fields and a datagridview to show the search results.

what is the best way to implement the link between the form and the database

the storded procedure can receive a variable number of parameters, but always returns the same number of fields.

Top

Re: Windows Forms Data Controls and Databinding Search form dynamic sql

Rong-Chun Zhang - MSFT

Hi erzfezsf

Your stored procedure may be something like:

Code Snippet

CREATE PROCEDURE Sel_Query

@Columns varchar(1000),

@tbName varchar(50),

@Condition varchar(1000)

BEGIN

Declare @sql varchar(2500)

set @sql = 'Select '+@Columns+' from '+@rbName+' where '+@Condition

EXEC @sql

END

Use several comboboxes to show tables in the database and columns in these tables. Set parameters for this stored procedure via SqlParameter.

Hope it helps.

Regards.

Top