Click here to Skip to main content
15,398,575 members

Comments by Master Vinu (Top 173 by date)

Master Vinu 3-Feb-19 5:49am View
   
thx rick
Master Vinu 27-Jan-17 6:34am View
   
-1 not working , give error
Master Vinu 27-Jan-17 4:08am View
   
pls give syntex..thanks in advance
Master Vinu 27-Jan-17 4:08am View
   
pls give syntex..thanks in advance
Master Vinu 27-Jan-17 4:06am View
   
pls give syntex..thanks in advance m new to sql
Master Vinu 27-Jan-17 3:35am View
   
Not working ..pls give syntex..thanks in advance
Master Vinu 21-Jan-16 5:01am View
   
yes.. i did .request you to give me a solution
Master Vinu 21-Jan-16 4:55am View
   
yes
Master Vinu 21-Jan-16 4:51am View
   
when m try to get it on crystal it show me only name of image
Master Vinu 21-Jan-16 4:43am View
   
Beginner Luck

i wan to convert in sql 2008 view not in code
Master Vinu 6-Jan-16 7:44am View
   
thank you
Master Vinu 6-Jan-16 5:52am View
   
digimanaus,

what if i wan it for all docnum.
Master Vinu 6-Jan-16 5:27am View
   
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.
Master Vinu 11-Jun-15 6:13am View
   
sorry pwasser..its mistakenly click....

thx for help:)
Master Vinu 11-Jun-15 3:58am View
   
error: cannot be applied operands of type
Master Vinu 14-May-15 8:09am View
   
tell me ...which file you need m new to jscript
Master Vinu 5-Feb-15 6:00am View
   
date format is 2015-02-10 12:59:00.000

could y pls help me out with code

thx
Master Vinu 5-Feb-15 5:53am View
   
date format is 2015-02-10 12:59:00.000

could y pls help me out with code

thx
Master Vinu 5-Feb-15 5:37am View
   
how to apply pls expalain in code
Master Vinu 28-Jan-15 5:45am View
   
multipart identifier (system.data.datarowview) could not be bound.
Master Vinu 28-Jan-15 5:31am View
   
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();
Master Vinu 28-Jan-15 5:30am View
   
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();
Master Vinu 28-Jan-15 5:27am View
   
int
Master Vinu 28-Jan-15 5:00am View
   
now its give multipart identifier error
Master Vinu 28-Jan-15 4:49am View
   
int value .query is working properly
Master Vinu 23-Jan-15 6:46am View
   
could y pls correct the query then ..yhx in advance
Master Vinu 22-Jan-15 4:45am View
   
.now its not get in code
Master Vinu 22-Jan-15 4:45am View
   
yes value is contain
Master Vinu 11-Dec-14 1:30am View
   
yes qty and rate is column data type is int
Master Vinu 8-Apr-14 5:52am View
   
thx for efforet... solved
Master Vinu 8-Apr-14 5:52am View
   
solve ...thx for effrot
Master Vinu 8-Apr-14 5:52am View
   
Pheonyx.... y r right lblBtkName.innerHTML.toLowerCase()) m checking false value


thx bro...
Master Vinu 31-Mar-14 2:02am View
   
In query its group by menu..so plesae check in sql with query record which shown 5 times print . and check the record...??
Master Vinu 28-Mar-14 5:14am View
   
Hi ,
have y get double record??
Master Vinu 21-Mar-14 5:46am View
   
raul@ pls chk the updated question ..so you will get better idea of my requirement.
thx in advance
Master Vinu 21-Mar-14 5:32am View
   
Deleted
k .Raul. thx for the updation of solution let me check.
Master Vinu 21-Mar-14 5:20am View
   
Deleted
var AppQues = document.getElementById("_ctl1_PXP_SUN_APRSL_QSN_1", "_ctl1_PXP_SUN_APRSL_QSN_2", "ctl1_PXP_SUN_APRSL_QSN_3", "ctl1_PXP_SUN_APRSL_QSN_4");

AppQuest(AppQues, lang);

Collapse | Copy 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", "Nein"];
}

}
}


give srror:its give error object required
Master Vinu 21-Mar-14 4:34am View
   
its give error object required
Master Vinu 21-Mar-14 4:13am View
   
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";
}

}
}

}
Master Vinu 21-Mar-14 3:32am View
   
please leet me know its perfect or not?
Master Vinu 21-Mar-14 3:29am View
   
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
Master Vinu 21-Mar-14 3:16am View
   
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
Master Vinu 21-Mar-14 3:15am View
   
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????

}

}
Master Vinu 18-Mar-14 5:21am View
   
thx nobritrial
Master Vinu 14-Mar-14 1:36am View
   
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)
{
Master Vinu 14-Mar-14 1:33am View
   
"javascript:OnMOCPageLoad()" hyperlink below that part is it right?
i wan to call
function DDLYesNo(mdl1, lang)
{
Master Vinu 23-Jan-14 4:18am View
   
thx bro...
Master Vinu 23-Jan-14 4:06am View
   
it gives:
Where DocDate Between '1/22/2014' AND '1/23/2014 FirstName ='MOHAN'
Master Vinu 23-Jan-14 4:02am View
   
ya i have removed but gives error:

Incorrect syntax near 'MOHAN'.
Unclosed quotation mark after the character string ''.
Master Vinu 2-Dec-13 7:02am View
   
error occoured when m trying to add "CAST (T0.U_Sales_Type AS VARCHAR(50)) AS SALETYPE "
Master Vinu 2-Dec-13 6:49am View
   
could y please make one change , so rest i will manage same
Master Vinu 2-Dec-13 6:45am View
   
which way i can split the query??please guide the same.
Master Vinu 22-Nov-13 5:35am View
   
its numeric field
Master Vinu 22-Nov-13 4:39am View
   
maciej thx but not working
Master Vinu 22-Nov-13 4:38am View
   
no rahul its not working
Master Vinu 22-Nov-13 4:13am View
   
yes
Master Vinu 22-Nov-13 4:11am View
   
thx rahul. but,

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

hope y get my prob?
Master Vinu 22-Nov-13 3:57am View
   
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.
Master Vinu 7-Aug-13 6:36am View
   
i hv create the coonection on top of the page ...plese chnged in code to know ...yhx in advance sir
Master Vinu 2-Jul-13 9:00am View
   
nice bro....thx very much...
Master Vinu 25-Jun-13 5:51am View
   
thx pheonyx..... i have update the query, but when i was try to update the cell value its neither update nor give any error
Master Vinu 6-Apr-13 8:32am View
   
thx dear
Master Vinu 30-Mar-13 7:17am View
   
not working it shows very narrow snap and not showing images also
Master Vinu 30-Mar-13 5:33am View
   
it shows very narrow snap and not showing images also
Master Vinu 28-Mar-13 6:58am View
   
thx i have check the folder but now its shows invalid mail attchment.
Master Vinu 28-Mar-13 4:41am View
   
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
Master Vinu 28-Mar-13 3:53am View
   
not working below ismy code
Master Vinu 28-Mar-13 3:14am View
   
Failed to map the path '/Images/book-cover.jpg'.
Master Vinu 28-Mar-13 2:39am View
   
ya image in available in folder but iam using

using System.Web.Mail;

is it used for Attachment
Master Vinu 28-Mar-13 1:56am View
   
thx pallavi for reply

but it gives error attachment could not found
Master Vinu 27-Mar-13 11:36am View
   
dear how to do this??
Master Vinu 27-Mar-13 11:34am View
   
pls help to complete ..thx in advance
Master Vinu 27-Mar-13 11:33am View
   
Deleted
ya
Master Vinu 27-Mar-13 8:01am View
   
ya problem solved thx
Master Vinu 27-Mar-13 7:55am View
   
thx brother...
Master Vinu 24-Jan-13 6:10am View
   
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
Master Vinu 24-Jan-13 6:03am View
   
i need current date in short format only, .text not working
Master Vinu 22-Jan-13 5:08am View
   
cmd.Parameters.AddWithValue("Date", dateTimePicker1.Value.ToString());
Master Vinu 22-Jan-13 5:03am View
   
yer dear i have taken datatype-- datetime in sql
Master Vinu 16-Jan-13 4:42am View
   
i hv used above query
Master Vinu 16-Jan-13 4:42am View
   
Deleted
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; } }
Master Vinu 16-Jan-13 4:20am View
   
no dear Shanu2rick - after delete its blackout
Master Vinu 16-Jan-13 3:22am View
   
please make changes in code pls
Master Vinu 16-Jan-13 3:20am View
   
iam filling datagridview on search of jobcardno from database, but if jobcardno not found in database i want some message should be thrown
Master Vinu 16-Jan-13 3:16am View
   
RowHeaderSelect
Master Vinu 16-Jan-13 3:04am View
   
pls make changes in above code/...thx in advance
Master Vinu 16-Jan-13 2:32am View
   
but its clear all rows of datagridview
Master Vinu 16-Jan-13 2:31am View
   
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;

}
}
Master Vinu 16-Jan-13 2:15am View
   
not getting clear
Master Vinu 11-Jan-13 6:03am View
   
i need runtime total change in textbox 3 when user chnage value in textbox2
Master Vinu 11-Jan-13 5:53am View
   
above i have made the code but not working
Master Vinu 11-Jan-13 5:52am View
   
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();
}
}
Master Vinu 11-Jan-13 5:52am View
   
no dear its not working total not comes on textbox 3
Master Vinu 4-Jan-13 4:28am View
   
Input string was not in a correct format.
Master Vinu 4-Jan-13 4:19am View
   
giving error input string is not valid
Master Vinu 4-Jan-13 4:17am View
   
not working ) expected
Master Vinu 3-Jan-13 7:46am View
   
where is column name
Master Vinu 3-Jan-13 7:41am View
   
pls make changes in above query
Master Vinu 3-Jan-13 7:40am View
   
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;
}

}
Master Vinu 3-Jan-13 7:39am View
   
Deleted
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; } }<pre lang="c#"></pre>
Master Vinu 3-Jan-13 7:30am View
   
this is my code pls modify it

thx in advance
Master Vinu 3-Jan-13 7:30am View
   
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; } }
Master Vinu 3-Jan-13 7:23am View
   
ya ....dynamically add on last row
Master Vinu 3-Jan-13 7:21am View
   
i need col1 row total on end????? pls clarify me
Master Vinu 3-Jan-13 7:19am View
   
i need col1 row total on end????? pls clarify me
Master Vinu 3-Jan-13 7:08am View
   
need on windows form.
Master Vinu 3-Jan-13 6:54am View
   
using above query i get data in gridview
Master Vinu 3-Jan-13 6:53am View
   
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;
}

}
Master Vinu 3-Jan-13 6:52am View
   
no iam confuse how to do it?? m new to c#
Master Vinu 3-Jan-13 5:39am View
   
i want enable textbox for this user
if ((SettingManger.Instance.User != "deepakp") || (SettingManger.Instance.User != "ravis"))
{
textbox1.Enabled
}
Master Vinu 3-Jan-13 5:37am View
   
if (SettingManger.Instance.User != "deepakp" ||"ravi") not working
Master Vinu 2-Jan-13 5:57am View
   
thx aarti
Master Vinu 2-Jan-13 5:45am View
   
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
Master Vinu 1-Jan-13 4:46am View
   
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
Master Vinu 1-Jan-13 4:35am View
   
thx OriginalGriff644K

not but i want normal user make entry with current date in system.
Master Vinu 17-Dec-12 4:07am View
   
thx krunal
Master Vinu 17-Dec-12 2:52am View
   
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();

}

}
Master Vinu 17-Dec-12 2:51am View
   
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
Master Vinu 17-Dec-12 2:45am View
   
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();

}

}
Master Vinu 17-Dec-12 2:38am View
   
thx but still there is error
Master Vinu 17-Dec-12 2:36am View
   
give folloeing errro on :using (SqlDataReader objQty = com.ExecuteReader())

There is already an open DataReader associated with this Command which must be closed first.
Master Vinu 17-Dec-12 1:59am View
   
no dear ...not working same error when debug the code on objconnection.open()
Master Vinu 7-Dec-12 6:55am View
   
@himanshu coluld you please make changes in code...

thx in advaance man
Master Vinu 7-Dec-12 6:19am View
   
same query i am execute in sql its working but while click on button its not working ....whats the reason behind that...
Master Vinu 7-Dec-12 6:17am View
   
record not updated while click on button
Master Vinu 7-Dec-12 5:57am View
   
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'
Master Vinu 3-Dec-12 2:59am View
   
need code for delete row through datagrid
Master Vinu 3-Dec-12 2:54am View
   
solved by your query ,,,,need query for delete from gridview.
Master Vinu 3-Dec-12 2:30am View
   
ya null value
Master Vinu 3-Dec-12 2:22am View
   
didnt get your point
Master Vinu 3-Dec-12 2:06am View
   
update statement not retrived gives error : incorect syntax near where clause
Master Vinu 3-Dec-12 1:57am View
   
no i have cross chked its fine
Master Vinu 3-Dec-12 1:53am View
   
shamboo pls do the changes in code
Master Vinu 3-Dec-12 1:52am View
   
date is datetime how should i change
Master Vinu 1-Dec-12 7:27am View
   
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();
}
Master Vinu 1-Dec-12 7:11am View
   
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
Master Vinu 1-Dec-12 5:24am View
   
i have already posted it sir
Master Vinu 1-Dec-12 5:17am View
   
ya while add this url in my application i got error that its link is not valid
Master Vinu 1-Dec-12 5:08am View
   
@Krunal R :
http://localhost:2268/Service1.svc error while using this url in add reference services
Master Vinu 1-Dec-12 4:32am View
   
krunal, but i have to edit it after fetching data in gridview and update it..
pls advice how to code it
Master Vinu 30-Nov-12 6:06am View
   
THANKS EVERYONE.............
Master Vinu 30-Nov-12 4:37am View
   
i need for windoes form not for web form sorry i have not mention in question
Master Vinu 30-Nov-12 4:35am View
   
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
Master Vinu 23-Nov-12 6:23am View
   
ow chk .i have tried this but not working
Master Vinu 19-Nov-12 6:00am View
   
thx OriginalGriff
Master Vinu 12-Nov-12 6:29am View
   
i need 1-5 from combobox
Master Vinu 12-Nov-12 6:06am View
   
same error :
Master Vinu 12-Nov-12 5:59am View
   
what i hav to do for that?
Master Vinu 12-Nov-12 5:57am View
   
0
Master Vinu 12-Nov-12 5:56am View
   
Deleted
1-3
Master Vinu 12-Nov-12 5:47am View
   
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
}
}
Master Vinu 12-Nov-12 5:32am View
   
where is rangevalidator in windows form
Master Vinu 12-Nov-12 2:13am View
   
but i have to take data from column to validate?? hot to do this
Master Vinu 12-Nov-12 2:06am View
   
windows
Master Vinu 5-Nov-12 5:09am View
   
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
Master Vinu 5-Nov-12 5:06am View
   
there is no error but combo4 does not contain any value
Master Vinu 5-Nov-12 4:27am View
   
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
Master Vinu 5-Nov-12 3:36am View
   
yes ..its mistake...sorry for mistakenly write checkbox.... pls update if you have any hint
Master Vinu 5-Nov-12 3:36am View
   
sorry for sorry for mistakenly write checkbox.... pls update if you have any hint
Master Vinu 5-Nov-12 3:31am View
   
sorry for mistakenly write checkbox
Master Vinu 5-Jul-12 2:18am View
   
where i can find GAC and Entity dll please advise
Master Vinu 15-Jun-12 5:00am View
   
thanks upniwesh
Master Vinu 15-Jun-12 4:56am View
   
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();
Master Vinu 15-Jun-12 4:55am View
   
any code without if condition
Master Vinu 15-Jun-12 4:53am View
   
Dear I dont wan use if condition
Master Vinu 15-Jun-12 4:50am View
   
datetime
2012-06-07 10:53:33.093
Master Vinu 14-Jun-12 6:22am View
   
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
Master Vinu 14-Jun-12 4:50am View
   
ds not found
Master Vinu 14-Jun-12 4:24am View
   
.give below error
The multi-part identifier "System.Data.DataRowView" could not be bound.
Master Vinu 14-Jun-12 1:55am View
   
tanveer its not working...could you please tell which code is for page load and which one is for combobox selected??
Master Vinu 13-Jun-12 6:25am View
   
THANKS, NOW ITS WORK BUT AFTER SELECTING VALUE IN COMBOBOX RELATED VALUE IN TEXTBOX DOSENT CHANGE PLEASE ADVISE.
Master Vinu 13-Jun-12 5:50am View
   
code is not working properly, combobox getting default below message:

System.Data.DataViewManagerListItemTypeDescriptor
Master Vinu 13-Jun-12 5:12am View
   
could you please change in code i cant understand