Comments by Member 14898617

Member 14898617 17-Jan-21 0:01am View

hi thank you so much for your answer , now i am getting below error:

Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: ''object' does not contain a definition for 'get_Range''

at the line :

Excel.Range r = excelApp.get_Range(activeworksheet.Cells[i, 1]);

i searched and tweaked some lines but no use, please help me.

Member 14898617 15-Jan-21 8:24am View

hi thank you your response ..i am creating VSTO for excel so i have no other options..could you please help me with the solution

Member 14898617 23-Dec-20 5:31am View

sorry for being less clear in the question ..let me explain further so that you can help me ..

I have installed SQLEXPRESS in my system and built an app (winforms) in visual studio by creating a database in my sqlserver.

Now my application is complete , i have to install my app on my client(4-5 pc) all or on the same LAN and after installation when the user is trying to connect to my database located in my system he is getting below error:

System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)

By searching online , i followed below points:

I have enabled Remote connection in my SSMS

I have TCP/IP in sql server configuration manager

I have created rule in firewall to allow port 1433

i then restarted sql server configuration manager

But when i opened TCP/IP window of Protocols of SQLEXPRESS in my sql server configuration manager , at the bottom TCP dynamic port was 12345(filled with other number) and my TCP port was empty.

I gain changed the TCP port to 1433 and cleared the number in TCP dynamic port and restarted SQL server services.

After all this when i reinstall the app in my client system i am getting the same error again , so please guide me if i am missing anything. And how to deploy winform Make Application With Database Can Access in Many Computers?

Member 14898617 21-Dec-20 2:37am View

hi. Thank you for your suggestion i found out that the error is coming at the line: ```lotNoTextBox.Text = cmd.ExecuteScalar().ToString();``` as the "coilnotext" box and lot number was not matched , but again i have used try block right? ..it must show the exception in messagebox and let me use my application , but why it stepping out of the application itself?

Member 14898617 18-Dec-20 5:45am View

Thank you so much ..

Member 14898617 18-Dec-20 5:14am View

i didn't quite get it ..can you please show the example code?

Member 14898617 17-Dec-20 0:53am View

Thank you so much for your suggestion ..i have closed the connection and inserted and refresh statement after delete ..now it is working

Member 14898617 12-Dec-20 5:41am View

Thank you for the response

Member 14898617 12-Dec-20 5:40am View

Thank you so much ..now i got the idea

Member 14898617 12-Dec-20 3:40am View

Thank you for the suggestion ,i'll try the same

Member 14898617 12-Dec-20 3:03am View

Hi ..Thanks for your comment but now the data can't be saved because the data in the first form is adding as a separate row , and the data in this form is adding as a separate row , please help..

Member 14898617 11-Dec-20 23:08pm View

Hello ...Thank you for your response but kindly don't judge before knowing full...in our process the product might get rejected for variety of reasons , and a single product can contain up to three defects ..hence three combo box are needed to fill in the data for the three columns sometimes it will one or two or three or nil based on the product status. Any idea how to do it?

Member 14898617 12-Aug-20 7:45am View

Thank you so much it is working now

Member 14898617 12-Aug-20 7:09am View

Hello inline with your suggestion , i have made the below code but agin i am struck in formatting this sql to include double quotes , could you please help me :

private readonly OleDbConnectionStringBuilder _builder = new OleDbConnectionStringBuilder
        {
            Provider = "Microsoft.ACE.OLEDB.12.0",
            DataSource = "S:\\Customer_Service\\Wires\\Database for CSC\\Backend data of databse do not open\\CSC.accdb"
        };

        public DataTable Read()
        {
            var dt = new DataTable();

            using (var cn = new OleDbConnection { ConnectionString = _builder.ConnectionString })
            {

                using (var cmd = new OleDbCommand { Connection = cn })
                {
                    cmd.CommandText = @"TRANSFORM Count(Complaint_Number) AS [Total Numbers]
                                       SELECT Nature_of_problem, Count(Complaint_Number) AS[Total Numbers of Issues]
                                       FROM master_table
                                       GROUP BY Nature_of_problem
                                       PIVOT Format(Complaint_Received_On, "mmm") In("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"); 
                    cn.Open();
                    dt.Load(cmd.ExecuteReader());
                }
            }

            return dt;

        }
    }

Member 14898617 12-Aug-20 5:23am View

Thank you for your response , the problem is i am using access database
(csc.accdb in my desktop)as datasource not MYSQL which can be stored procedures , so could you please help me in executing directly by coding ? and populate the same in data grid box n form load event.

Member 14898617 12-Aug-20 5:12am View

Thank you so much sir will try .

Member 14898617 12-Aug-20 4:49am View

Exactly sir ..Thank you for understanding ..very sorry for my late reply.

Member 14898617 12-Aug-20 3:37am View

Thank you so much for your response , I added the Missing OR , but as i am new i have on doubt : if the field contains both number , text and symbol like = S200(ABS) , how should we write the like statement?

Member 14898617 6-Aug-20 23:37pm View

Thank you very much for your reply , but X value is not a single pint here
this is the scalar query output:
Size_in_mg(X axis)--------- Count(of Size_in_mg)(Y-axis)
100-300mg --------- 3
200-400mg --------- 2
300-500mg --------- 1

Member 14898617 6-Aug-20 2:05am View

I didn't get you(could you please explain further?) , the columns "Size in mg" in the query can be used as series right? then for y axis i can use total column , my question is how to make this scalar query as data source to my chart .

Member 14898617 30-Jul-20 5:13am View

Hi thank you for your reply ..this has nothing to do with the variable names because i corrected them already ..the solution i want is to know how to create two reports using same data set & that too one table & graph & show them in two report viewers of same form

Member 14898617 30-Jul-20 5:10am View

Sir ..I knew what the error was but the problem was even after updating my database & dataset this was showing and yesterday i didn't knew i have to manually correct them in program.cs file which is auto-generated .Now this is solved .Please know that not everyone is as intelligent and smart as you ..there are guys like us who are slow learners.

Member 14898617 29-Jul-20 22:34pm View

Yeah ,how to correct this guide me please?

Comments by Member 14898617 (Top 23 by date)