Comments by Amar chand123

Amar chand123 10-May-21 10:08am View

I want my custom user control bind with datagridview textbox column and if i type text or click datagridview textbox column my user control show like combobox dropdown box

Amar chand123 13-Feb-21 7:56am View

New Error show'String or binary data would be truncated.
The statement has been terminated.'
when i use this
private void SaveUpdateMess()
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DataConnectionString"].ConnectionString);
string SaveUpdateBM = "if exists (Select * from BD where OrderNo = @OrderNo and BodyM = @BodyM) Begin update BD set Mess = @Mess where OrderNo = @OrderNo and BodyM = @BodyM End else Begin insert into BD (OrderNo, BodyM, Mess) VALUES (@OrderNo, @BodyM, @Mess) End";
using(SqlCommand cmd = new SqlCommand(SaveUpdateBM, con))
{
con.Open();

cmd.Parameters.AddWithValue("@OrderNo", txtOrder_No.Text);
cmd.Parameters.AddWithValue("@BodyM", row.Cells["BodyM"].ToString());
cmd.Parameters.AddWithValue("@Mess", row.Cells["Mess"].ToString());

cmd.ExecuteNonQuery();
con.Close();
}
}

}

Amar chand123 8-Dec-20 7:40am View

My problem is not datagridview filters my problem is who i use datagridview combobox autocomplete List show data. like if my custom datasource have Apple, Banana and i press
"A" in datagridview combobox cell than autocomplete suggestion show Apple and Banana, only only Apple

Amar chand123 8-Dec-20 7:40am View

My problem is not datagridview filters my problem is who i use datagridview combobox autocomplete List show data. like if my custom datasource have Apple, Banana and i press
"A" in datagridview combobox cell than autocomplete suggestion show Apple and Banana, only only Apple

Amar chand123 23-Oct-20 6:58am View

Then how my workplace application create in database in his executable path my workplace application install in Direct C:\ not in C:\Program Files

Amar chand123 2-Oct-20 8:24am View

Sir Than any other database suggestion

Amar chand123 2-Oct-20 7:18am View

My database create if not exist in Folder but problem i have i need writing full code like "Select form table1.columns1... table2.Columns1.... inner join "
I want create a query in database and save like i save in query design in access database

Amar chand123 7-Sep-20 5:38am View

Problem solved mistake in 'ReceiptNo' data type when i change column data type into 'INT' problem solved

Amar chand123 22-Aug-20 8:16am View

Thank you for answering and hardwork but this time it's all my fault because when i run code in c# winform i forgot put LoadStudentData(); in Form Load that's why query run in SQL but not in winform, i find my mistake when i put breakpoint in my code

Amar chand123 8-Aug-20 7:08am View

When i change "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Data\DataFile.mdf;Integrated Security=True"
to
"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\HP\source\repos\Project1\Project1\Data\DataFile.mdf;Integrated Security=True"

my Code Woke Fine and Data Save and show in my DataBase Correctly
but I Don't Know, Why?

Amar chand123 8-Aug-20 7:07am View

When i change "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Data\DataFile.mdf;Integrated Security=True"
to
"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\HP\source\repos\Project1\Project1\Data\DataFile.mdf;Integrated Security=True"

my Code Woke Fine and Data Save and show in my DataBase Correctly
but I Don't Know, Why?

Amar chand123 8-Aug-20 4:54am View

Deleted

Still Not Work

Amar chand123 8-Aug-20 3:04am View

Problem still same

Amar chand123 24-Jul-20 8:47am View

Already have this in bin Folder

Amar chand123 24-Jul-20 8:03am View

NuGet Microsoft.ReportViewer.WinForm v10.0.402191.1

Amar chand123 14-Jul-20 3:18am View

i know Problem in Connection String but i Don't Know why Code Break when i Select Date Before May-2019 or After Jun-2021, i Don't Know What Connection Between My DateTimePicker Date and My Connection String Because when i Select Date Between jun-2019 to may-2021 Code Work Fine Without any Error

Amar chand123 14-Jul-20 2:53am View

in DB my Column Data Type is Date/Time and Format is ShortDate

but Problem is not this Because Code Work Fine
Problem is if i Select Date Before May-2019 or After jun-2021 my Code Break and Code Break Point is ---con.Open();

Amar chand123 14-Jul-20 2:38am View

i use [Date] but Problem is not in [Date]
if i Select my First DateTimePicker 01/06/2020 Result Show Correctly -- 2
and if i Select Date 01/01/2020 Result Show Correctly ---4

but when is select date before may/2019 in DateTimePicker My Code Breaked
i not know why my code Break if i select date before may/2019

Amar chand123 14-Jul-20 2:23am View

i try this Before but not work
Error show
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Data type mismatch in criteria expression.

Amar chand123 16-Jun-20 10:26am View

Thank You

Amar chand123 16-Jun-20 10:25am View

table name

Amar chand123 16-Jun-20 10:20am View

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Syntax error in INSERT INTO statement.

Amar chand123 16-Jun-20 3:39am View

Thank You

Amar chand123 16-Jun-20 3:31am View

i Improved My Question

Amar chand123 14-Jun-20 10:18am View

Thank you both sir without your suggestions i my self not realise problem

Amar chand123 14-Jun-20 9:22am View

thank you for remind i understand my mistake
for (int i = 1; i <= dataGridView1.Rows.Count - 1; i++)
replace with
for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)

and it's work fine

Amar chand123 14-Jun-20 9:10am View

Not work i already try but problem is when i use this in my excel file in first row column show and second row empty show

Amar chand123 14-Jun-20 9:06am View

here my code

for (int i = 1; i < dataGridView1.Columns.Count + 1; i++)
{
xlWorkSheet.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;
}

for (int i = 1; i <= dataGridView1.Rows.Count - 1; i++)
{
for (int j = 0; j <= dataGridView1.Columns.Count - 1; j++)
{
DataGridViewCell cell = dataGridView1[j, i];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}

Amar chand123 14-Jun-20 9:04am View

I use this but when i use this column show but first row replace by column header text

Amar chand123 14-Jun-20 8:38am View

Sir do you have any good suggestions? Like same codes for export textbox and datagridview in export

Amar chand123 14-Jun-20 8:21am View

I have a datagridview in datagridview data show from access database. And in datagridview i have 8 columns and 12 rows and if i use closedxml for export then data export correctly, but i don't want use closedxml because i dont know how i export same textbox data before export datagridview data

Amar chand123 14-Jun-20 7:03am View

Column Count is right

Datagridview1.RowCount show 8

Amar chand123 12-Jun-20 9:43am View

Thank you sir and sorry but can you solve in closexml my first column show filters i want remove

Amar chand123 12-Jun-20 9:31am View

Using ClosedXML.Excel;

Amar chand123 6-Jun-20 22:43pm View

Thank you i try

Amar chand123 6-Jun-20 12:27pm View

Thank you

Amar chand123 6-Jun-20 12:22pm View

Thank you for suggestions now I think i really need a book of learning language after lockdown i go and buy a book

Amar chand123 6-Jun-20 12:15pm View

Sir i try DateTime filldate = DateTime.Now; in this comment i only typed in smallcase

Amar chand123 6-Jun-20 12:11pm View

I am new in language so when i have any problem i try search solutions on Google and now i everyday spend one hour on YouTube for learning language

Amar chand123 6-Jun-20 11:38am View

Thank you for answering sir Richard and why i convert string to datetime and again datetime because when i try Google i found some said so i just try

Amar chand123 6-Jun-20 11:34am View

First i try only datetime filldate = datetime.now but it's not working than i try Google for solutions then i find this so i try but its also not work then i place question here because here i always learn new

Amar chand123 4-Jun-20 5:14am View

Thank you, i finally understand my mistake and it's work fine
I use this

int a,b;
a = Convert.ToInt32(montsPart);
b = Convert.ToInt32(yearPart);

da.SelectCommand.Parameters.AddWithValue("@year",b);
da.SelectCommand.Parameters.AddWithValue("@Mont",a);

Amar chand123 4-Jun-20 4:58am View

But when i use Year(cu.date) = 2020 it's work fine and data show in datagridview
But when i try Year(cu.date) = @Year it's not work

Amar chand123 3-Jun-20 22:03pm View

i try this code but still not Work, in my dataGridView data not show

Amar chand123 31-May-20 5:25am View

Thank you sir Phil.o for this trouble

Amar chand123 31-May-20 5:15am View

Still no data show in dataGrid
but Again Thank You of Try Hard For Solving may be it's not Possible in Access Query

Amar chand123 31-May-20 4:57am View

But When i use this
string DataLoad = "SELECT Format([Date], "mm/yyyy") AS "Month/Year", Count([Name]) AS "Count" FROM [customer] GROUP BY Format([Date], "mm/yyyy")";

my String show Error because "" in my String Like "mm/yyyy"

Amar chand123 31-May-20 4:50am View

and Thank you

Amar chand123 31-May-20 4:49am View

sorry i tagged wrong

Amar chand123 31-May-20 4:38am View

DataGridView Show Nothing Without any Error

i use access database

And i Use this for save date in DataBase
cmd.Parameters.AddWithValue("@Date", dateTimePicker1.Value.Date);

and in DataBase Column type is DateTime

if i use my this String

string DataLoad = "select month(Date) as Months, count(Name)as Count from customer GROUP BY month(Date) ";
then data show in dataGridView by Only Group by Months

Amar chand123 31-May-20 4:27am View

not Working

Amar chand123 28-May-20 4:46am View

Thank you

Amar chand123 28-May-20 4:45am View

Deleted

Thank you

Amar chand123 28-May-20 2:48am View

Only one user Project and auto incremented column problem is if i have 10 data in database and i delete last 7 data and add new data in database then SrNo is show 11 not 7

Amar chand123 28-May-20 2:44am View

Not working

Amar chand123 21-May-20 23:43pm View

Thank you sir Richard deeming, sir can you have a suggestion for me where i learn SQL syntax online because i just started learning programming from internet

Amar chand123 21-May-20 10:50am View

Sir Chill60, i READ your shared link and download project source code for study and try to learn and thank you for sharing and answering my question

Amar chand123 21-May-20 5:27am View

and if i use this code then data show other then "OPEN" but Where Status is "OPEN" Data Not Show

string query = "SELECT Number, CustomerName, MobileNo, SecMobileNo, Status FROM customer WHERE Status=@Status ";
query += " OR Number LIKE '%' + @SearchTerm + '%'";
query += " OR CustomerName LIKE '%' + @SearchTerm + '%'";
query += " OR MobileNo LIKE '%' + @SearchTerm + '%'";
query += " OR SecMobileNo LIKE '%' + @SearchTerm + '%'";
query += " OR @SearchTerm = ' '";

string constr = ConfigurationManager.ConnectionStrings["TestData"].ConnectionString;
using (OleDbConnection con = new OleDbConnection(constr))
{
using (OleDbCommand cmd = new OleDbCommand(query, con))
{
cmd.Parameters.AddWithValue("@SearchTerm", txtName.Text.Trim());
cmd.Parameters.AddWithValue("@Status", "OPEN");
using (OleDbDataAdapter sda = new OleDbDataAdapter(cmd))
{

DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
}
}
}

Amar chand123 21-May-20 5:10am View

I try but still not work

Amar chand123 20-May-20 12:56pm View

Thank you sir Phil.o

Amar chand123 20-May-20 11:38am View

i just start Programming and start Learn From Internet and from my Past Mistakes, so can you explain me in easy way how i solve this Problem just some help

Amar chand123 16-May-20 4:02am View

I try but i have a problem
Data in combo box is
Maha
Rana
Ralan
Rahul

If i type combo box "ral" and press tab key., and if i type "Rahul" and press tab then in my combo box value always show "rana"

Amar chand123 14-May-20 9:47am View

i use replace Maximum to this work but only a small Problem if row count is divide 100 in decimal value
hScrollBar1.SmallChange=100/c;

Amar chand123 14-May-20 9:11am View

problem is when i use my ScroolBar(); Code, then ScrollBar Show like This
https://pasteboard.co/J8kR3tu.jpg

but in my database i have 10 Rows
i want scroll Position go left to right after 10 click but as a you see scroll position show fill already in scrollBar

Amar chand123 14-May-20 8:48am View

i want use my ScrollBar work like Next Perv Button and i Use this Code
private void hScrollBar1_Scroll(object sender, ScrollEventArgs e)
{

if (e.OldValue < e.NewValue)
btnNext.PerformClick();

if (e.OldValue > e.NewValue)
btnPrev.PerformClick();
}

Amar chand123 14-May-20 8:42am View

In winform and i want my scrollbar bar maximum value show as par my database rows Count i mean for example my database table have 10 Rows then i want if i click right side button in scrollbar then in 10 click my scrollbar position show in last and if i click left button 10 time then scroll position go back in first position but when i use this code scrollbar not work scrollbar never go left or right

Amar chand123 6-May-20 6:10am View

Now i try remove "Count" and use "max" in statement and is worked, us that right or not

Amar chand123 4-May-20 3:13am View

Thank You Sir

Amar chand123 4-May-20 3:12am View

Thank You Sir

Amar chand123 1-May-20 9:06am View

private void LoadSr()
{

foreach (DataGridViewRow row in dataGridView2.Rows)
{
DateTime dt = Convert.ToDateTime(dataGridView2.CurrentRow.Cells["LasttDate"].Value);
DateTime dt1 = Convert.ToDateTime(dataGridView2.CurrentRow.Cells["TodayDate"].Value);
int d12 = (dt - dt1).Days;

row.Cells["DueDay"].Value = d12;

}
}
sir, i Try This Code But Show Error i am is new in Programming so can you help

An unhandled exception of type 'System.InvalidCastException' occurred in mscorlib.dll

Additional information: Object cannot be cast from DBNull to other types.

Amar chand123 4-Apr-20 3:58am View

Reason For Using SaveRecord, SaveRecord1, because I Have Three Table in DataBase and i don't Know any Code For Save Data in all Three Table by a Single Code For Save Data So I use Three Code, Because i Started Learning Coding from last 2 months.
Sir can you Any Code Save data in Three Different Table by one code

Amar chand123 4-Apr-20 3:49am View

Thank You

Amar chand123 28-Mar-20 11:25am View

Thanks

Amar chand123 19-Mar-20 4:47am View

Thank you both

Amar chand123 19-Mar-20 2:42am View

Thank you KarstenK
i am beginner in Coding so make a small mistake all the time
Do you have any Website or app whereby i learn syntax mistakes

Amar chand123 7-Mar-20 9:34am View

Thank You

Amar chand123 4-Mar-20 8:02am View

Thank you

Amar chand123 4-Mar-20 7:42am View

Thank you for help Sir
this code work Fine and sir can you explain me what Problem in your previous Code for my Future reference

Amar chand123 4-Mar-20 6:10am View

Sir, if i use Date 31/08/2020 in your Code then i Result Show---
30/09/2020
30/11/2020
28/02/2021
28/06/2021
28/11/2021
28/05/2022
28/12/2022
28/08/2023

Amar chand123 4-Mar-20 5:34am View

there is no Error Message Problem is When i use loop Month then as you see when i use (Date1) Loop Code Work is Fine, but when i use ( Date2 or 3 ) my loop code not work Properly ( if i use date 31/12/2020 then after 28th February my code change date 28/03/2021, 28/04/2021, 28/05/2021 but i need this Result 31/03/2021, 30/04/2021, 31/05/2021

Amar chand123 4-Mar-20 5:23am View

Sir Tomas Takac
how to use this code in my Code, can you modify my code because i am is beginner in Programming, thank you

Amar chand123 3-Mar-20 4:37am View

but how i apply this code in my Datagridview
For SrNo. "increment" i use this Code:

private void LoadSr()
{
int i = 1;
foreach(DataGridViewRow row in dataGridView1.Rows)
{
row.Cells["SrNo"].Value = i; i++;
}
}

Can You Modify this Code for my Date Column Because i am Beginner in Programming
so i not Modify code, So if You Help Me for Change in Code, it help me a lot,
Thank You

Amar chand123 1-Mar-20 9:30am View

i Find a Method And its Working
my Access Database Column is Autonumber But Its Edit by this code
Please Check this Code

private void Autonumber1()
{
String connstring = ConfigurationManager.ConnectionStrings["Data"].ConnectionString;
OleDbConnection con = new OleDbConnection(connstring);
string Query = "select count(*) from customer";
OleDbCommand cd = new OleDbCommand(Query, con);
try
{
con.Open();
int count = Convert.ToInt16(cd.ExecuteScalar()) + 1;
textBoxLoanNumber.Text = count.ToString("00000");
textBoxLoanNumber.Enabled = false;
}

finally
{
con.Close();
}
}

Amar chand123 1-Mar-20 8:47am View

Is There such code, that can count rows in my database's customer Table
than we add +1 and show in Textbox than i saved database
because now i try save manually data in access autonumber column by c# Textbox and Data Successfully Saved

Amar chand123 1-Mar-20 7:19am View

then what is Solution for this Problem
because if i use ms access autonumber there is problem if i delete any data then autonumber not reset and access autonumber option is read-only

Amar chand123 29-Feb-20 8:59am View

Thank you @Wendelius
it Work :) [Really Month is Reserved Word]
I change "Month" into "Mont" and Error is gone, Finally Problem Solved,
I try Search all Internet for this Problem Solution, now i am relaxed
Now All Data Saved Without any Error

Thank Your

Amar chand123 29-Feb-20 5:04am View

Sir if you sand me your Email than i send my Project File
Same Error

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Syntax error in INSERT INTO statement.

Amar chand123 29-Feb-20 4:59am View

output from debug

'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities\12.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities.Sync\12.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.Sync.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio.Debugger.Runtime\12.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Debugger.Runtime.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Users\VIJAY\Documents\Visual Studio 2013\Projects\New folder\Fincorp\bin\Debug\Fincorp.vshost.exe'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.DataSetExtensions\v4.0_4.0.0.0__b77a5c561934e089\System.Data.DataSetExtensions.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.CSharp\v4.0_4.0.0.0__b03f5f7f11d50a3a\Microsoft.CSharp.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'Fincorp.vshost.exe' (CLR v4.0.30319: Fincorp.vshost.exe): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enable

Amar chand123 29-Feb-20 4:56am View

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Syntax error in INSERT INTO statement.

Amar chand123 29-Feb-20 4:52am View

Fixed MONTHLYINSTALMENT, but Problem Remaining Same
https://snipboard.io/6h09Vl.jpg
Design View

Amar chand123 29-Feb-20 4:47am View

Deleted

Changed but Problem Remaining Same.

Amar chand123 29-Feb-20 4:39am View

Wendelius, i change "Value" into "values" But Problem Remaining Same

Comments by Amar chand123 (Top 92 by date)