Comments by 16041984 (Top 36 by date)

no answers

yes i am not understand how to write query to display number of count with status in grid view.i m newbie

Consultant_Name
tcs
morphees
krutika



Status
InProcess
C V Sent
InProcess


how can i get in gridview count of cv received with consultant name

if (DDConsultantName.SelectedIndex != 0)
{
string strValue = string.Empty;
cn.Open();
//SqlConnection con = new SqlConnection("server=servername;uid=sa;password=p@ssw0rd;database=test;Connect Timeout=200; pooling='true'");
SqlCommand cmd = new SqlCommand(" select ContactPerson_EmailID from Consultant_Detail where Consultant_ID='" + DDConsultantName.SelectedValue.ToString() + "'", cn);
//cn.Open();
strValue = (string)cmd.ExecuteScalar();
cn.Close();
TextBox1.Text = strValue;
// LBEmailId.DataTextField = "ContactPerson_EmailID";
// LBEmailId.DataValueField = "Consultant_ID";

}

i will do one thing i take one textbox then add email id's in listbox ....problem solved....thank u for ur reply all of u

yes i set autopostback = true for dropdown
<asp:DropDownList ID="DDConsultantName" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DDConsultantName_SelectedIndexChanged">

it shows

when i use this it is running but not showing any result in listboxemailid i.e LBEmailID.pls help

entire CV into sqlserver database

waiting for ur reply sir

if i exclude port number but still it gives error as i mentioned above.
any help......management studio is not installed in my pc.i first made tables in remote server and in connection string i access remote database

m_cnADONetConnection.ConnectionString =

"Server=113.30.141.10:1433;" +
"Database=CorporateDatabase1;" +
"Integrated Security=false;" +
"Connect Timeout=30;" +
"User id=sa;Password=password)";

but it gives error as
Error is A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

thx

thx dear i am add this code on form load..and change the date of system after 15 days and it works application exit.thx yaar.god bless u

on which event of form i use this code?? on form load or where

how sir?

thx it works

i solved it myself by taking in array and using proc.start....thx for help

i stored all interview time in time column how can i comapre the both time and date any ides...i m newbie

see i am stored interview time for candidate in db on what time he have interview in company.i have 100 of candidate going for interview in different comapany.when date and time matches with current time and date i want to show pop up message..aley u have interview on 6 pm

thx dear

thx

plz give me any solution

thx now it's working
thx to Prabhakaran Soundarapandian sir

it's working also i have error on code
if ((DtAdv1.ToString().Substring(0, 5) == drNameShow.GetString(3).Substring(0, 5)) || (DtAdv2.ToString().Substring(0, 5) == drNameShow.GetString(3).Substring(0, 5)))
{

on if statement it gives error if (DtMain.ToString().Substring(0, 5) == drNameShow.GetString(3).Substring(0, 5))
plz help.i m newbie

on if statement it gives error if (DtMain.ToString().Substring(0, 5) == drNameShow.GetString(3).Substring(0, 5))
plz help.i m newbie

on if statement it gives error
if (DtMain.ToString().Substring(0, 5) == drNameShow.GetString(3).Substring(0, 5))

thats right i save in database.but how can i pick from database dynamicaly or from folder.any idea?? i am newbie

but on input form add the time of save i have browse button and user have n number of cv with different name.how can i identify this?

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

if (e.ColumnIndex == 0)
{
Process myProc;
myProc = Process.Start("C:\\Resumeupload\\employee.docx");

//myProc.CloseMainWindow();

}
i use that code but it opens employee.docx on each click of datagridview link..i want to open a cv of a search candidate.
how????

but how can i find cv of a perticular person from folder.i have cv of 100 candidate and when i click on gridview link button i want to display cv of a search candidate????? i want to open it in my application