Comments by prashanth manoj

prashanth manoj 25-Feb-23 5:30am View

after filter database values select using down arrow keys in drop down that is what my issue

prashanth manoj 25-Feb-23 5:29am View

Deleted

after filter database values select using down arrow keys in drop down that is what my issue

prashanth manoj 7-Dec-22 8:04am View

path stroke (color) change if (ck_bill_no == 0)

prashanth manoj 17-Nov-22 0:47am View

how to retrieve all rows from table in wpf c#

prashanth manoj 17-Sep-22 8:36am View

txtCompanyName.Text = ds.Tables[0].Rows[0][0].ToString();
txtCaption.Text = ds.Tables[0].Rows[0][1].ToString();
txtAddress1.Text = ds.Tables[0].Rows[0][2].ToString();
txtAddress2.Text = ds.Tables[0].Rows[0][3].ToString();
txtMobile.Text = ds.Tables[0].Rows[0][4].ToString();
txtEmail.Text = ds.Tables[0].Rows[0][5].ToString();
txtGstin.Text = ds.Tables[0].Rows[0][6].ToString();
txtCloudApi.Text = ds.Tables[0].Rows[0][7].ToString();
txtUsername.Text = ds.Tables[0].Rows[0][8].ToString();
txtPassword.Password = ds.Tables[0].Rows[0][9].ToString();
txtcombox.Text = ds.Tables[0].Rows[0][10].ToString();

txtActivationKey.Text = ds.Tables[0].Rows[0][12].ToString();
txtCreatedby.Text = ds.Tables[0].Rows[0][13].ToString();
txtDate.Text = ds.Tables[0].Rows[0][14].ToString();

prashanth manoj 17-Sep-22 8:33am View

error through URI is empty

prashanth manoj 14-Sep-22 1:51am View

how to fetch image path load from another form

prashanth manoj 10-Sep-22 1:37am View

private void btnEdit_Click(object sender, RoutedEventArgs e)
{
try
{
Add_Profile ap = new Add_Profile();

ap.txtCompanyId.Text = SetValueForText1;
ap.txtCompanyName.Text = SetValueForText2;
ap.txtCaption.Text = this.dataGrid.CurrentItem.ToString();
ap.txtAddress1.Text = this.dataGrid.CurrentCell.ToString();
ap.txtAddress2.Text = this.dataGrid.CurrentColumn.ToString();
ap.txtMobile.Text = this.dataGrid.CurrentItem.ToString();
ap.txtEmail.Text = this.dataGrid.CanUserAddRows.ToString();
ap.txtGstin.Text = this.dataGrid.IsSynchronizedWithCurrentItem.Value.ToString();
ap.txtCloudApi.Text = this.dataGrid.ItemsSource.ToString();
ap.txtUsername.Text = this.dataGrid.CanUserResizeRows.ToString();
ap.txtPassword.Password = this.dataGrid.CanUserResizeRows.ToString();
ap.txtcombox.Text = this.dataGrid.CanUserResizeRows.ToString();
ap.txtActivationKey.Text = this.dataGrid.CanUserResizeRows.ToString();
ap.ShowDialog();
// ap.picUserimage.Source = this.dataGrid.CurrentColumn.ToString();
//DataRowView dataRowView = (DataRowView)((Button)e.Source).DataContext;
//String ProductName = dataRowView[1].ToString();
//String ProductDescription = dataRowView[2].ToString();
//MessageBox.Show("You Clicked : " + ProductName + "\r\nDescription : " + ProductDescription);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}

private void btnDel_Click(object sender, RoutedEventArgs e)
{
//if (txt.Text == "-" || lbluserid.Text == "")
//{
// MessageBox.Show("You are Not able to Delete Please select item", "Question", MessageBoxButton.OK, MessageBoxImage.Warning);
//}
try
{
if (MessageBox.Show("Do you want to Delete?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{

}
DataRowView dataRowView = (DataRowView)((Button)e.Source).DataContext;
String ProductName = dataRowView[1].ToString();
String ProductDescription = dataRowView[2].ToString();
MessageBox.Show("You Clicked : " + ProductName + "\r\nDescription : " + ProductDescription);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}

prashanth manoj 3-Sep-22 1:25am View

how to make single instance application

prashanth manoj 2-Sep-22 6:28am View

register form show at only register after run a project show login form

prashanth manoj 31-Aug-22 4:15am View

stored procedure insert on button click,
and bind comcobox
how to retrieve data from other table

prashanth manoj 31-Aug-22 3:59am View

BindComboBox()
buffercombo()

how to data bring from databse to other table coloumn in c# wpf

prashanth manoj 31-Aug-22 3:57am View

Deleted

private void Button_Click(object sender, RoutedEventArgs e)
{

try
{
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
int id = int.Parse(txtUserId.Text);
string branch = cmboBranch.SelectedValuePath, emp_name = cmboSelEmp.Text, user_type = cmboSelUser.Text, user_name = txtUsername.Text, password = txtPassword.Password.ToString();
SqlCommand cmd = new SqlCommand(" insert_user '" + id+"','"+user_name+"','"+password+"','"+user_type+"','"+branch+"','"+ emp_name + "'", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Saved");

}
catch ( SqlException ex)
{

MessageBox.Show(ex.Message);
}

}

private void BindComboBox()
{
SqlConnection con = new SqlConnection(ConnectionString);
cmboSelUser.Items.Clear();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select privilege from user_privilege";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);

foreach (DataRow dr in dt.Rows)
{
cmboSelUser.Items.Add(dr["privilege"].ToString());
cmboSelUser.ItemsSource = ((IListSource)dt).GetList();
cmboSelUser.DisplayMemberPath = "privilege";
cmboSelUser.SelectedValuePath = "id";

}

con.Close();
}
private void buffercombo()
{
SqlConnection con = new SqlConnection(ConnectionString);
cmboSelEmp.Items.Clear();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select name from add_employee";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
cmboSelEmp.Items.Add(dr["name"].ToString());
cmboSelEmp.DisplayMemberPath = "name";
cmboSelEmp.SelectedValuePath = "eid";

}
con.Close();
}

private void Button_Click1(object sender, RoutedEventArgs e)
{
this.Close();
}

prashanth manoj 29-Aug-22 3:48am View

did not work...
give me other examples..

prashanth manoj 27-Aug-22 8:52am View

its working..
Thank you so much..

prashanth manoj 27-Aug-22 7:07am View

i thimk so... but i how to make it??

prashanth manoj 27-Aug-22 7:07am View

Deleted

System.Windows.Controls.TextBox is the key here...

txtCompanyId = type: System.Windows.Controls.TextBox
txtCompanyId.Text = type: System.String

i getting confusing ...

prashanth manoj 27-Aug-22 6:57am View

in executenonquery 'No mapping exists from object type System.Windows.Controls.TextBox to a known managed provider native type.'
again show this

prashanth manoj 27-Aug-22 6:56am View

in executenonquery();

prashanth manoj 27-Aug-22 6:56am View

again show this...
No mapping exists from object type System.Windows.Controls.TextBox to a known managed provider native type.'
again show this

prashanth manoj 27-Aug-22 6:28am View

'No mapping exists from object type System.Windows.Controls.TextBox to a known managed provider native type.'
again show this

prashanth manoj 27-Aug-22 6:26am View

did not work

prashanth manoj 27-Aug-22 6:25am View

did not work

Comments by prashanth manoj (Top 23 by date)