this can help select table1.cli from table1 left join table2 on table1.cli=table2.cli where table2.cli is null
a hamidy
Posts
-
SQL Script -
Upload Data using c#I have asked this question several times in Code Project. I am looking to upload my data with resume feature. Is there any .Net Class or namespace or any algorithm to provide me a feature where i can upload my data in different segments and with resume feature?
-
Source Grid cell Focus Problemput your source grid name ("grid1" change it to your grid name") there my friend. I think you better use the key up event, that can easly handle enter or arrow keys.
-
Resume uploadDear All, I am using FtpWebRequest to upload my data to ftp address, i am successful in uploading my data, but what bothers me is whenever my upload fails even at last byte of data, it again starts from zero i mean from beginning. i am looking to find out about how to provide resume feature for uploading data? What an idea is behind resume feature? do we have standard algorithm for that? i have dedicated server.
-
Tab Formwrite following to your form load and tabControl selectedIndexChange Event.
void setFocus(byte selectedIndex) { switch (selectedIndex) { case 0: //focus control that u want txt1.Focus(); break; case 1: //focus control that u want cmb1.Focus(); break; } } void TabControl1SelectedIndexChanged(object sender, EventArgs e) { setFocus((byte)tabControl1.SelectedIndex); } void Frm_Form7Load(object sender, EventArgs e) { //setFocus(0); If by default first tab is selected setFocus((byte)tabControl1.SelectedIndex); }
set the control TabIndex to 0 and you can also set the TabControl TabStop to false. -
How to create Control array?follow the steps.
TextBox[] textBoxes=new TextBox[]{txt1,txt2,txt3,txt4};
foreach(TextBox t in textBoxes)
t.Text=string.Empty;where txt1,txt2,.. is the name of TextBoxes in Form.
-
SelectedIndexChanged problem regarding combobox and data gridGraus is true, but i suggest you to use following when binding comboBox to a data source. you have selected index change event for combo box, you can simply de attach that event before binding comboBox or what ever causes comboBox change index event to fire. i have a combobox named "cmb1" with selectedIndexChangeded named "cmb1ChangedIndex". simply follow this cmb1.selectedIndexChanged -=selectedIndexChangeded; //do binding here for both comboBox or what ever cause comboBox selectedChanged event //to fire then cmb1.selectedIndexChanged +=selectedIndexChangeded ;
-
ComboBoxes and DataGridViews...you can ignore the selectedIndexChanged Event whenever you want. follow the steps to ignore the event and put it back when the form completly load. comboBox1.SelectedIndexChanged -=comboBox1_selectedIndexChanged; do your work here and then comboBox1.SelectedIndexChanged +=comboBox1_selectedIndexChanged; "comboBox1_selectedIndexChanged" is the selected Index Change event of comboBox1
-
FTP or Database Connectivity using c#thx dude, I only mean connection speed, Database connectivity is fast or FTP connectivity. not data exchange, no query just connection
-
FTP or Database Connectivity using c#Dear All, I have a database in web server and off course i have ftp account and user name of that web server too. i have got 1mb upload bandwith, my question is very simple. I have application which connects to database in web server, and the same i have application which connects to FTP. for database connectivity i am using SqlConnection and for FTP Connectiviy i am using WebClient. which of these connectiviy is fast? FtP connectiviy or Database Connectiviy?
-
create enum at run timeI have gone to create enum at run time using System.Reflection.Emit.EnumBuilder. i can create enums at run time using mentioned class. and hopefully it can be destroyed when you close the application.
-
create enum at run timewell i have checkboxes in many forms. when they are checked i want to insert the enum value in the child table. i can assign the value without run time, but i am afraid if the table "id" is changed than i am stack, so i am creating enums at run time.
-
create enum at run timeDear All, I have a DataTable which has 8 records and it will have more records at later too. the data table has two fields (columns) which is "Id" and "Name". I would like to create enum based on "Name" field and the value of enum based on "Id" field. Is it possible to create enums at run time using c#.
-
Windows Service Applicationcan you please have more detail on client application and the interaction way between client and server application. you mean i should call window forms from my installer class.
-
Windows Service Applicationyeah you are right, but if we enable the option "Allow User to Interact with Desktop". we can show UI to the user. i have enabled this option through code, still i need to restart my computer to get affected. I want this without restarting the system.
-
Windows Service ApplicationDear All, I have created a very basic and simple windows service application using c# in vs 2005. i have override the "onstart" method and i want that when my service starts a message should appear just to confirm that service starts running. the service starts successfully but no message appears to me. i have tried to write that message to a file but still no file is created. this the code bellow
protected override void OnStart(string[] args)
{
System.Windows.Forms.MessageBox.Show("Service is start...");
}i have googled and used topic in msdn to create window service application. why the message box does not appear when i am starting the service?
-
Convert mdb to xmlconversion in a table level is simply done using DataTable methods. but i am looking to fully convert .mdb file into .xml file, including all object in .mdb file.
-
Convert mdb to xmlDear All, I am looking to convert .mdb access file into xml file using c#. I have googled,but i didnt find any topic related. I am sure about java which does this conversion, but i dont know about c#. such features is available in c# or not?
-
Maniupulating information from a dataset to save it into an array ???? [modified]put your dataset Table in to dataview and then convert it back to table with distinct values and then covert datatable to array as follow C# [code] DataView dv=new DataView(ds.Tables["tblName"]); DataTable temp=dv.ToTable(true,"col1","col2"); [/code] now convert temp to array
-
Error while executing .aspx in web browser [modified]Dear All, I am having problem in configuring .aspx in window xp. i have configured IIS and create it virtual directory as well. when i am executing .aspx file from "localhost/folderName" I am getting the following error Line 26: Line 27: Line 28: <sessionstate timeout="60"></sessionstate> Line 29: <authorization> Line 30: <allow users="?" /></authorization> the error appears in this line Source File: C:\Inetpub\wwwroot\folderName\web.config Line: 28 I can run this without any error from VWD or VS 2005.
modified on Saturday, March 28, 2009 2:22 AM