The line
Code:
list=new lisviewitem(dr.rows["empno"].tostring());
Code:
list=new lisviewitem(dr["empno"].tostring());
Hope now it will work.
GayathriP
Last Activity: Dec 22 '09, 01:33 PM
Joined: Oct 15 '07
Location:
-
Hi Uday,
The line
should be
<B>The Datarow object doesn't have the rows collection</B>
Hope now it will work. -
Accessing the inbox through MAPI using C# .NET
This article discusses about how can we access the inbox through MAPI using C# .NET. It also discusses about how to store the attachment in the local directory, how to create a folder in the inbox
Need to add the reference Microsoft CDO 1.21 Library to the project
[CODE=c#]
//Declarations
MAPI.Message objMsg, objMsg_Arch;
MAPI.Messages objMsgs;
MAPI.Attachment objAttach;
MAPI.Attachment s... -
The Port No is not specified to send the email.
It can be done by
SmtpServer.Port = <PortNo>;Leave a comment:
-
...Code:VB .NET If blnProvider Then ' If Provider is used strConn = "Provider=" & m_strProvider & ";Data Source=" & m_strServer & ";user id=" & m_strUserName & ";Password=" & m_strPwd & ";OLE DB Services=-2" & g_objShared.CMS_SEP Else ' If Driver is usedLeave a comment:
-
...Code:[B]C# .Net[/B] [DllImport("KERNEL32.DLL", EntryPoint = "GetPrivateProfileStringA", //BestFitMapping=true, //PreserveSig=false, //ThrowOnUnmappableChar=true, SetLastError = true, CharSet = CharSet.Ansi, ExactSpelling = true, CallingConvention = CallingConvention.StdCall)]Leave a comment:
-
You can create a folder using the following statement
System.IO.Direc tory.CreateDire ctory(strDir);Leave a comment:
-
Just a small change in your code will work fine.
DataRow2 = dt.Select("Skil lsId = '" & x ?& "' AND SkillLevel > '" & y & "' AND
MonthsExperienc e > ' " & w & "' ", "Name DESC")
Hope this works for youLeave a comment:
-
You can use isDBNull(<Field Value) to check for the NULL values.Leave a comment:
-
To find the dimensions's length individually you need to use the GetLength method.
Sample Code is
Code://C# Code string[,] arrstr = new string[2, 3]; MessageBox.Show(arrstr.GetLength(0).ToString()); ---> displays 2 MessageBox.Show(arrstr.GetLength(1).ToString()); ---> displays 3
Leave a comment:
-
You can use the following Windows APIs to run the external commands in VB6.
1. WaitForSingleOb ject
2. CreateProcessA
3. GetExitCodeProc ess
4. CloseHandle
If you are not able to make it, i can provide you the codeLeave a comment:
-
You have to just concatenate the month and year as m & "\" & y. But your database should be restructured to store the value.Leave a comment:
-
sorry for that. i will follow the same in futureLeave a comment:
-
The string ret do not have any value and hence when split will return a zero length array. So while referring a[1] returning the error.Leave a comment:
-
The code should be
[code=cpp]
for(int intOuter=0; intOuter<datata ble.Rows.Count; intOuter++)
{
for(int intInner=0; intInner<datata ble.Columns.Cou nt; intInner++)
{
MessageBox.Show (datatable.Rows[intOuter].ItemArray[intInner].ToString())
}
}[/code]Leave a comment:
-
[code=vbnet]
SqlConnection objconn = new SqlConnection(" server=<ServerN ame>;database=< DatabaseName>;u id=<UserID>;pwd =<Pwd>");
objconn.Open();
//This will not fill data as the where condition is specified as 1=2
SqlDataAdapter sa = new SqlDataAdapter( "select query where 1=2", objconn);
DataTable dt = new DataTable();
sa.Fill(dt);
...Leave a comment:
-
[code=vbnet]
SqlConnection objconn = new SqlConnection(" server=<ServerN ame>;database=< DatabaseName>;u id=<UserID>;pwd =<Pwd>");
objconn.Open();
SqlDataAdapter sa = new SqlDataAdapter( "select query where 1=2", objconn);
DataTable dt = new DataTable();
sa.Fill(dt);
for (int intLoop...Leave a comment:
-
You can use the following code to format a number in desired format
int a =12345;
MessageBox.Show (a.ToString("#0 000000.00#"));
The Output will be 0012345.00Leave a comment:
No activity results to display
Leave a comment: