Comments by Master Vinu (Top 173 by date)

Not working ..pls give syntex..thanks in advance

yes.. i did .request you to give me a solution

yes

when m try to get it on crystal it show me only name of image

Beginner Luck

i wan to convert in sql 2008 view not in code

thank you

digimanaus,

what if i wan it for all docnum.

ClgCode DocNum Recontact CardName DocTotal
10828 6821 2015-11-23 00:00:00.000 A. CO PICARD SEALING 100460.000000
10829 6821 2015-12-01 00:00:00.000 A. CO PICARD SEALING 100460.000000
10906 6821 2015-12-02 00:00:00.000 A. CO PICARD SEALING 100460.000000

i wan last row cause its maximum one or you can say latest one. docnum 6821 is common. T0.RECONTACT IS DATE FIELD.

sorry pwasser..its mistakenly click....

thx for help:)

error: cannot be applied operands of type

tell me ...which file you need m new to jscript

date format is 2015-02-10 12:59:00.000

could y pls help me out with code

thx

date format is 2015-02-10 12:59:00.000

could y pls help me out with code

thx

how to apply pls expalain in code

multipart identifier (system.data.datarowview) could not be bound.

SqlDataAdapter da = new SqlDataAdapter("select * from VisitorPass where PassNo = " + (vfind.SelectedValue.ToString()), objConn1);
DataSet ds = new DataSet();
da.Fill(ds, "VisitorPass");
if (ds.Tables["VisitorPass"].Rows.Count > 0)
{
MainCombo.SelectedValue = ds.Tables["VisitorPass"].Rows[0]["PassType"].ToString();
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["PassNo"].ToString();
VdateTimePicker1.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Date"].ToString());
Dttimein.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Timein"].ToString());
Dttimeout.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Timeout"].ToString());
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["VisitorsName"].ToString();
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["Purpose"].ToString();
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["ToSee"].ToString();
vauthcombo.SelectedValue = ds.Tables["VisitorPass"].Rows[0]["AuthorisedSign"].ToString();

SqlDataAdapter da = new SqlDataAdapter("select * from VisitorPass where PassNo = " + (vfind.SelectedValue.ToString()), objConn1);
DataSet ds = new DataSet();
da.Fill(ds, "VisitorPass");
if (ds.Tables["VisitorPass"].Rows.Count > 0)
{
MainCombo.SelectedValue = ds.Tables["VisitorPass"].Rows[0]["PassType"].ToString();
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["PassNo"].ToString();
VdateTimePicker1.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Date"].ToString());
Dttimein.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Timein"].ToString());
Dttimeout.Value = Convert.ToDateTime(ds.Tables["VisitorPass"].Rows[0]["Timeout"].ToString());
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["VisitorsName"].ToString();
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["Purpose"].ToString();
txtvpassno.Text = ds.Tables["VisitorPass"].Rows[0]["ToSee"].ToString();
vauthcombo.SelectedValue = ds.Tables["VisitorPass"].Rows[0]["AuthorisedSign"].ToString();

int

now its give multipart identifier error

int value .query is working properly

could y pls correct the query then ..yhx in advance

.now its not get in code

yes value is contain

yes qty and rate is column data type is int

thx for efforet... solved

solve ...thx for effrot

Pheonyx.... y r right lblBtkName.innerHTML.toLowerCase()) m checking false value


thx bro...

In query its group by menu..so plesae check in sql with query record which shown 5 times print . and check the record...??

Hi ,
have y get double record??

raul@ pls chk the updated question ..so you will get better idea of my requirement.
thx in advance

its give error object required

raul@ pls confirm the code

function AppQuest(ddl,lang) {

if (lang.toLowerCase() == "de-de")


{
for (var i = 1; i < 5; i++) {
if (document.getElementById("_ctl1:PXP__APRSL_QSN_" + i).value == "") {
document.getElementById("_ctl1:PXP__APRSL_QSN_" + i).value = "Ja";
}

}
}

}

please leet me know its perfect or not?

var AppQues = document.getElementById["_ctl1_PXP_SUN_APRSL_QSN_1", _ctl1_PXP_SUN_APRSL_QSN_2", "ctl1_PXP_SUN_APRSL_QSN_3"];

AppQuest(AppQues, lang);

function AppQuest(ddl,lang) {

if (lang.toLowerCase() == "de-de")


{
for (i = 1; i < ApprQues.length; i++)
{ var ddlVal = ["Ja", "Nein"]; }
}

}

raul@ m trying above code please let me whats wrong in that
thx in advance

Maciej Los see the code above so you will get good idea.

if languge is de then i wan change "yes " to "fgdg"

let me know if am doing wrong in that and suugest code in function
thx in advance

var AppQues = document.getElementById("_ctl1_PXP_SUN_APRSL_QSN_1", "_ctl1_PXP_SUN_APRSL_QSN_2", "ctl1_PXP_SUN_APRSL_QSN_3");

\\declare var above

then fuction
AppQuest(AppQues, lang);

then write code :
function AppQuest(ddl,lang) {

if (lang.toLowerCase() == "de-de")

{
\\need code here????

}

}

thx nobritrial

prakash pls make changes on body section as per m y above code..thx in advance cause i didnt get that code

iwan to call
function DDLYesNo(mdl1, lang)
{

"javascript:OnMOCPageLoad()" hyperlink below that part is it right?
i wan to call
function DDLYesNo(mdl1, lang)
{

thx bro...

it gives:
Where DocDate Between '1/22/2014' AND '1/23/2014 FirstName ='MOHAN'

ya i have removed but gives error:

Incorrect syntax near 'MOHAN'.
Unclosed quotation mark after the character string ''.

error occoured when m trying to add "CAST (T0.U_Sales_Type AS VARCHAR(50)) AS SALETYPE "

could y please make one change , so rest i will manage same

which way i can split the query??please guide the same.

its numeric field

maciej thx but not working

no rahul its not working

yes

thx rahul. but,

actually i wan 1 rows only with record like 1 10 0 .

hope y get my prob?

Thx Rahul, but its not resolved my issue , it shows null value instead of 0, but rows are 2 only,
i wan 1 row only.

i hv create the coonection on top of the page ...plese chnged in code to know ...yhx in advance sir

nice bro....thx very much...

thx pheonyx..... i have update the query, but when i was try to update the cell value its neither update nor give any error

thx dear

not working it shows very narrow snap and not showing images also

it shows very narrow snap and not showing images also

thx i have check the folder but now its shows invalid mail attchment.

Invalid mail attachment 'H:\DWWebsite\Website\Website\Images\book-cover.jpg'.error is shown

i have add-- string path = Server.MapPath(@"Website/Images/book-cover.jpg");
folder name is website, still its not working

not working below ismy code

Failed to map the path '/Images/book-cover.jpg'.

ya image in available in folder but iam using

using System.Web.Mail;

is it used for Attachment

thx pallavi for reply

but it gives error attachment could not found

dear how to do this??

pls help to complete ..thx in advance

ya problem solved thx

thx brother...

dear all , on form load i need current date is default date in datetimepicker
how to get???
if user login tomorrow then he get tommorows date bydefault on datetimepicker

i need current date in short format only, .text not working

cmd.Parameters.AddWithValue("Date", dateTimePicker1.Value.ToString());

yer dear i have taken datatype-- datetime in sql

i hv used above query

no dear Shanu2rick - after delete its blackout

please make changes in code pls

iam filling datagridview on search of jobcardno from database, but if jobcardno not found in database i want some message should be thrown

RowHeaderSelect

pls make changes in above code/...thx in advance

but its clear all rows of datagridview

private void Delete_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridView2.SelectedRows.Count; i++)
{
string sql = "Delete from [SAPProduction].[ProductionData] " + " Where id = '" + dataGridView2.CurrentRow.Cells["id"].Value.ToString() + "' ";
// Jobcard = your desire Rows Jobcard Id

SqlCommand cmd = new SqlCommand(sql, objConn1);
objConn1.Open();
cmd.ExecuteNonQuery();
objConn1.Close();
MessageBox.Show("Record Deleted successfully...");

SqlDataAdapter dap1 = new SqlDataAdapter(sql, objConn1);
SqlCommandBuilder cmdbd = new SqlCommandBuilder(dap1);
DataTable dtb = new DataTable();
dap1.Fill(dtb);
BindingSource bs = new BindingSource();
bs.DataSource = dtb;
dataGridView2.DataSource = bs;

}
}

not getting clear

i need runtime total change in textbox 3 when user chnage value in textbox2

above i have made the code but not working

private void textBox5_TextChanged(object sender, EventArgs e)
{
double val1;
double val2;

bool validOne = Double.TryParse(txtTvalidqty.Text, out val1);
bool validTwo = Double.TryParse(textBox5.Text, out val2);

if (validOne && validTwo)
{
double result = val1 + val2;
txtAutoNo.Text = result.ToString();
}
}

no dear its not working total not comes on textbox 3

Input string was not in a correct format.

giving error input string is not valid

not working ) expected

where is column name

pls make changes in above query

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)13)
{
string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, objConn1);
DataSet ds = new DataSet();
objConn1.Open();
da.Fill(ds, "ProductionData");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "ProductionData";
objConn1.Close();
e.Handled = true;
}

}

this is my code pls modify it

thx in advance

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)13) { string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, objConn1); DataSet ds = new DataSet(); objConn1.Open(); da.Fill(ds, "ProductionData"); dataGridView2.DataSource = ds; dataGridView2.DataMember = "ProductionData"; objConn1.Close(); e.Handled = true; } }

ya ....dynamically add on last row

i need col1 row total on end????? pls clarify me

i need col1 row total on end????? pls clarify me

need on windows form.

using above query i get data in gridview

private void findlaksajob_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (char)13)
{
string sql = "SELECT [Jobcard],[Planqty],[Mouldqty],[Operator],[Supervisor],[Profilename],[Process],[Date],[Remark],[Approvedby],[id],[Division] FROM [SAPProduction].[ProductionData] WHERE JobCard ='" + findlaksajob.Text.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, objConn1);
DataSet ds = new DataSet();
objConn1.Open();
da.Fill(ds, "ProductionData");
dataGridView2.DataSource = ds;
dataGridView2.DataMember = "ProductionData";
objConn1.Close();
e.Handled = true;
}

}

no iam confuse how to do it?? m new to c#

i want enable textbox for this user
if ((SettingManger.Instance.User != "deepakp") || (SettingManger.Instance.User != "ravis"))
{
textbox1.Enabled
}

if (SettingManger.Instance.User != "deepakp" ||"ravi") not working

thx aarti

Error 8 'System.DateTime' does not contain a definition for 'Adddays' and no extension method 'Adddays' accepting a first argument of type 'System.DateTime' could be found (are you missing a using directive or an assembly reference?) G:\Spareage\Lib\CRSpareageFinance\GateForm\InventoryEntry.cs 385 60 CRSpareageFinance

ya thx all,

but i want normal user make entry with only current date in system, and "sa" means superuser can select any date and make entry,
thats my question

thx OriginalGriff644K

not but i want normal user make entry with current date in system.

thx krunal

private void textBox5_TextChanged(object sender, EventArgs e)
{
int nQty = 0;
int nActualQty ;
if (!int.TryParse(textBox5.Text, out nActualQty))
{
// Report problem to user - he typed wrong.

}

try
{
if (objConn1.State != ConnectionState.Open)
{
objConn1.Open();
}
string sql3 = "select qty from dbo.RateMouldQuantity where ratechart= '" + comboBox5.SelectedValue.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql3, objConn1);
DataTable dt = new DataTable();
da.fill(dt);
foreach(DataRow dr in dt.Rows) { nQty = int.Parse(dr["Qty"].ToString());
if (nQty < nActualQty)

{
MessageBox.Show("Qty is greater");
}

}

}


finally
{

objConn1.Close();

}

}

Error 8 'System.Data.SqlClient.SqlDataAdapter' does not contain a definition for 'fill' and no extension method 'fill' accepting a first argument of type 'System.Data.SqlClient.SqlDataAdapter' could be found (are you missing a using directive or an assembly reference?) G:\Spareage\Lib\CRSpareageFinance\GateForm\InventoryEntry.cs 279 56 CRSpareageFinance

dear please ammend the following query:::thx in advance dear

private void textBox5_TextChanged(object sender, EventArgs e)
{
int nQty = 0;
int nActualQty ;
if (!int.TryParse(textBox5.Text, out nActualQty))
{
// Report problem to user - he typed wrong.

}

try
{
if (objConn1.State != ConnectionState.Open)
{
objConn1.Open();
}
string sql3 = "select qty from dbo.RateMouldQuantity where ratechart= '" + comboBox5.SelectedValue.ToString() + "'";
using (SqlCommand com = new SqlCommand(sql3, objConn1))
{
using (SqlDataReader objQty = com.ExecuteReader())
{
if (objQty.Read())
{
nQty = Convert.ToInt32(objQty["Qty"]);
}
if (nQty < nActualQty)
{
MessageBox.Show("Qty is greater");
textBox5.Text = "";


}
}

}

}
finally
{

objConn1.Close();

}

}

thx but still there is error

give folloeing errro on :using (SqlDataReader objQty = com.ExecuteReader())

There is already an open DataReader associated with this Command which must be closed first.

no dear ...not working same error when debug the code on objconnection.open()

@himanshu coluld you please make changes in code...

thx in advaance man

same query i am execute in sql its working but while click on button its not working ....whats the reason behind that...

record not updated while click on button

cmd gives above query ---- UPDATE [SAPProduction].[ProductionData] SET Jobcard= '103382', Operator = 'Chandrashekhar (N)', Supervisor = 'SAMIKSHA(DIE)' , Profilename ='AFA' , Process='Moulding ORVT ' , Date='11/29/2012 11:54:45 AM' , Remark='we' , Approvedby='gtr' , Division ='Fabric ' Where id = '12'

need code for delete row through datagrid

solved by your query ,,,,need query for delete from gridview.

ya null value

didnt get your point

update statement not retrived gives error : incorect syntax near where clause

no i have cross chked its fine

shamboo pls do the changes in code

date is datetime how should i change

i have tried this but not working
private void Update_Click(object sender, EventArgs e)

{
for (int i = 0; i < dataGridView2.RowCount - 1; i++)
{
string sql = "UPDATE [SAPProduction].[ProductionData] SET " +

" Jobcard= '" + dataGridView2.Rows[i].Cells["Jobcard"].ToString() + "' , " +
" Planqty= '" + dataGridView2.Rows[i].Cells["Planqty"].ToString() + "', " +
" Mouldqty = '" + dataGridView2.Rows[i].Cells["Mouldqty"].ToString() + "', " +
" Operator = '" + dataGridView2.Rows[i].Cells["Operator"].ToString() + "', " +
" Supervisor = '" + dataGridView2.Rows[i].Cells["Supervisor"].ToString() + "' , " +
" Profilename ='" + dataGridView2.Rows[i].Cells["Profilename"].ToString() + "' , " +
" Process='" + dataGridView2.Rows[i].Cells["Process"].ToString() + "' , " +
" Date='" + dataGridView2.Rows[i].Cells["Date"].ToString() + "' , " +
" Remark='" + dataGridView2.Rows[i].Cells["Remark"].ToString() + "' , " +
" Approvedby='" + dataGridView2.Rows[i].Cells["Approvedby"].ToString() + "' , " +
" id='" + dataGridView2.Rows[i].Cells["id"].ToString() + "' , " + " Division='" + dataGridView2.Rows[i].Cells["Division"].ToString() + "' , " + " Od='" + dataGridView2.Rows[i].Cells["Od"].ToString() + "'";

SqlCommand cmd = new SqlCommand(sql, objConn1);
objConn1.Open();
cmd.ExecuteNonQuery();
objConn1.Close();
}

dear aziz , thx for your code but gives error jobcard column not found but its exsist and column id is primary we have to update it on id

i have already posted it sir

ya while add this url in my application i got error that its link is not valid

@Krunal R :
http://localhost:2268/Service1.svc error while using this url in add reference services

krunal, but i have to edit it after fetching data in gridview and update it..
pls advice how to code it

THANKS EVERYONE.............

i need for windoes form not for web form sorry i have not mention in question

thx zain--i have tried below code but not working

private void textBox3_TextChanged(object sender, KeyPressEventArgs e1, EventArgs e)
{
if (e1.KeyCode == Keys.Enter)
{
string sql = "[DocEntry],[JobCardNo],[ITEMNAME],[OD] ,[PlanQty],[FinalInspectionRemarks] ,[OrderDate] ,[Division] WHERE JobCardNo ='" + textBox3.Text.ToString() + "'";
SqlDataAdapter da = new SqlDataAdapter(sql, objConn1);
DataSet ds = new DataSet();
objConn1.Open();
da.Fill(ds, "ProductionInventoryReport");
dataGridView1.DataSource = ds;
//dataGridView1.DataBind();
dataGridView1.DataMember = "ProductionInventoryReport";
objConn1.Close();
e1.Handled = true;
}


}
i have tried this but not working

ow chk .i have tried this but not working

thx OriginalGriff

i need 1-5 from combobox

same error :

what i hav to do for that?

0

i have written code but getting error :
input string was not in correct format



private void saveButton_Click(object sender, EventArgs e)
{
// Get value from textBox
int number = Int32.Parse(textBox1.Text);

// Get value from combobox
int selcetedComboValue = Int32.Parse(comboBox1.SelectedItem.ToString());

// Validate Values
if (selcetedComboValue <= 5)
{
if (number <= 6)
{
// Valid Number
}
else
{
// Invalid Number
}
}
else if (selcetedComboValue <= 10)
{
if (number <= 12)
{
// Valid Number
}
else
{
// Invalid Number
}
}

where is rangevalidator in windows form

but i have to take data from column to validate?? hot to do this

windows

here are the updated table :first table :MaterialName
Material mid
AFA 1
AFB 2
AFC 3
AFD 4
AFE 5
AFJ 6
AFL 7
AFQ 8


second table:ProductionProcess
process mid Material
Wraping 1 AFA
Moulding 2 AFA

there is no error but combo4 does not contain any value

string sSql = "Select id from Master.Materialname where Material = '" + comboBox3.SelectedValue + "'";
SqlCommand cmd = new SqlCommand(sSql,objConn1);
int mid = Convert.ToInt32(cmd.ExecuteScalar());
string reffSql = "Select Process from Master.ProductionProcess where id = '" + mid + "'";
SqlCommand rcmd = new SqlCommand(reffSql, objConn1);
comboBox4.SelectedValue = Convert.ToString(rcmd.ExecuteScalar());

i have used above one but not working

yes ..its mistake...sorry for mistakenly write checkbox.... pls update if you have any hint

sorry for sorry for mistakenly write checkbox.... pls update if you have any hint

sorry for mistakenly write checkbox

where i can find GAC and Entity dll please advise

thanks upniwesh

My code is:
textBox3.Text=dss.Tables["ITdata"].Rows[0]["Itemno"].ToString();
textBox1.Text=dss.Tables["ITdata"].Rows[0]["Make"].ToString();
comboBox1.SelectedItem = dss.Tables["ITdata"].Rows[0]["ProductDetail"].ToString();
textBox2.Text = dss.Tables["ITdata"].Rows[0]["Modelno"].ToString();
dateTimePicker1.Value = dss.Tables["ITdata"].Rows[0]["pudate"].ToString();
textBox4.Text = dss.Tables["ITdata"].Rows[0]["VenderDetail"].ToString();
textBox5.Text = dss.Tables["ITdata"].Rows[0]["Approved"].ToString();
dateTimePicker2.Value = dss.Tables["ITdata"].Rows[0]["Warrenty"].ToString();
textBox6.Text = dss.Tables["ITdata"].Rows[0]["Issuedto"].ToString();
textBox7.Text = dss.Tables["ITdata"].Rows[0]["Department"].ToString();
dateTimePicker3.Value = dss.Tables["ITdata"].Rows[0]["Issueddate"];
comboBox2.SelectedItem = dss.Tables["ITdata"].Rows[0]["Reason"].ToString();
comboBox3.SelectedItem = dss.Tables["ITdata"].Rows[0]["Lifecycle"].ToString();

any code without if condition

Dear I dont wan use if condition

datetime
2012-06-07 10:53:33.093

iam selecting item in combobox 4 for eg:itemno,as well as i have 2 textboxes on form which shows item name and deparment
so i want data in textbox related to selected combobox item

ds not found

.give below error
The multi-part identifier "System.Data.DataRowView" could not be bound.

tanveer its not working...could you please tell which code is for page load and which one is for combobox selected??

THANKS, NOW ITS WORK BUT AFTER SELECTING VALUE IN COMBOBOX RELATED VALUE IN TEXTBOX DOSENT CHANGE PLEASE ADVISE.

code is not working properly, combobox getting default below message:

System.Data.DataViewManagerListItemTypeDescriptor

could you please change in code i cant understand