|
here is my code
i m trying to insert all the selected files in database having two tables
in First table (Details) columns are ID,Name and Path no
and in second table (Path ) columns are ID
i hav inserted Dataset (Dataset1 ) which is having both tables
btt sumhoww records couldnt be inserted
private void button1_Click(object sender, EventArgs e)
{
openFileDialog1.Filter = "Image (*.BMP;)|*.BMP|" + "All files (*.*)|*.*";
openFileDialog1.Multiselect = true;
openFileDialog1.Title = "Select BMP Image Files";
openFileDialog1.ShowDialog();
// string flnm = openFileDialog1.FileName;
flnms = openFileDialog1.FileNames;
int file_number = flnms.Length;
int pathno = 0;
DataSet1 dataset1 = new DataSet1();
DataSet1TableAdapters.DetailsTableAdapter detailsTableAdapter = new DataSet1TableAdapters.DetailsTableAdapter();
DataSet1TableAdapters.PathTableAdapter pathTableAdapter = new DataSet1TableAdapters.PathTableAdapter();
// int row_max = dataset1.Tables["bmpFront"].Rows.Count;
//int row_max = 188;
detailsTableAdapter.Connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"I:\\Picture to DB\\Picture to DB\\All Files.mdb\"");
detailsTableAdapter.Connection.Open();
pathTableAdapter.Connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"I:\\Picture to DB\\Picture to DB\\All Files.mdb\"");
pathTableAdapter.Connection.Open();
pathTableAdapter.Fill(dataset1.Path);
detailsTableAdapter.Fill(dataset1.Details);
int row_max_path = dataset1.Path.Rows.Count;
int row_max_details = dataset1.Details.Rows.Count;
for(int i=0;i<file_number;i++)>
{
string str;
str = flnms[i].ToString();
string[] str1 = str.Split('\\');
string name = str1[str1.Length - 1];
string path = getpath(str1) ;
// DataSet1 dataset1 = new DataSet1();
if (i == 0)
{
pathno = 999;
for (int j = 0; j < dataset1.Tables["Path"].Rows.Count; j++)
{
string str_compare = getpath((dataset1.Path[j][1].ToString()).Split('\\'));
if (str_compare == path)
{
pathno = int.Parse(dataset1.Path[j]["Path Id"].ToString());
}
else
{
continue;
}
}
}
if(pathno == 999)
{
pathTableAdapter.InsertQuery(row_max_path+1, path);
pathno = dataset1.Path.Rows.Count;
}
detailsTableAdapter.InsertQuery(row_max_details+1, name, pathno.ToString());
row_max_path++;
row_max_details++;
}
pathTableAdapter.Connection.Close();
detailsTableAdapter.Connection.Close();
|
|
|
|
|
Are you getting any error ?
IF Yes then on which line.
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
m nt getting error
bt records r nt inserted in table
|
|
|
|
|
paresh_sarjani wrote: m nt getting error
bt records r nt inserted in table
It would appear that some of the vowels are intermittently missing in the above. This makes it difficult to read. Perhaps your keyboard is broken and you need to replace it.
|
|
|
|
|
I want to send an email through my ASP.NET application.
Please help me.
I have the email address stored in the database .
|
|
|
|
|
|
can i send the email through the localhost, i mean through my machine directly ?
I have installed SMTP Virtual Servers in IIS 6.0, through the XP CD !
|
|
|
|
|
I think no but you can verify it whether are you able to send or not.
provide the SMTP server name is 172.0.0.1.
Send mail through the code and check on below location you will found there some file. Open it into the notepad.
C:\Inetpub\mailroot\Queue
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
it is giving
SmtpException<br />
Failure sending mail.
what shall I do ?
|
|
|
|
|
Where you are providing the SMTP Server name in Web.config file ?
IF Yes then examine like this:
<system.net>
<mailsettings>
<smtp from="test@par.com">
<network host="172.0.0.1 OR localhost" port="25" username="" password="" defaultcredentials="true" />
</smtp>
</mailsettings>
</system.net>
OR try external SMTP Server of Gmail
System.Net.Mail.SmtpClient email = new System.Net.Mail.SmtpClient();
email.Host = "smtp.gmail.com";
email.Port = 465 ;
............
............
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
again SmtpException
this time
The operation has timed out.
|
|
|
|
|
|
Parwej Ahamad wrote: which one you are using ?
anti-virus ?
avg free !
|
|
|
|
|
are you set on web.config file or using the Google SMTP server ?
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
|
|
Parwej Ahamad wrote: Are you logged on any IM ?
-> na...
code:
protected void Page_Load(object sender, EventArgs e)
{
string server;
server = "localhost";
string file = "data.xls";
file = Server.MapPath("~/data.xls");
MailMessage message = new MailMessage(
"apurvkolte@live.com",
"apurvkolte@gmail.com",
"Quarterly data report.",
"See the attached spreadsheet.");
Attachment data = new Attachment(file, MediaTypeNames.Application.Octet);
ContentDisposition disposition = data.ContentDisposition;
disposition.CreationDate = System.IO.File.GetCreationTime(file);
disposition.ModificationDate = System.IO.File.GetLastWriteTime(file);
disposition.ReadDate = System.IO.File.GetLastAccessTime(file);
message.Attachments.Add(data);
SmtpClient client = new SmtpClient();
client.Host = "smtp.gmail.com";
client.Port = 465;
client.Credentials = CredentialCache.DefaultNetworkCredentials;
client.Send(message);
ContentDisposition cd = data.ContentDisposition;
Console.WriteLine("Content disposition");
Console.WriteLine(cd.ToString());
Console.WriteLine("File {0}", cd.FileName);
Console.WriteLine("Size {0}", cd.Size);
Console.WriteLine("Creation {0}", cd.CreationDate);
Console.WriteLine("Modification {0}", cd.ModificationDate);
Console.WriteLine("Read {0}", cd.ReadDate);
Console.WriteLine("Inline {0}", cd.Inline);
Console.WriteLine("Parameters: {0}", cd.Parameters.Count);
foreach (DictionaryEntry d in cd.Parameters)
{
Console.WriteLine("{0} = {1}", d.Key, d.Value);
}
data.Dispose();
}
|
|
|
|
|
i have copied it from msdn
|
|
|
|
|
Let me check on my machine ?
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
i am going to sleep now.
we'll talk tomorrow ...
bye
gn
|
|
|
|
|
Below given code are working fine on my machine.
Note: Which I have mark as bold provide there your gmail id and password.
MailMessage MyMailMessage=new MailMessage();
MyMailMessage.From = new MailAddress("g.parwez@gmail.com");
MyMailMessage.To.Add("g.parwez@gmail.com");
MyMailMessage.Subject = "Parwej Testing !!!";
MyMailMessage.Body = "This is the test text for Parwej Ahamad";
SmtpClient SMTPServer=new SmtpClient("smtp.gmail.com");
SMTPServer.Port = 587;
SMTPServer.Credentials =new System.Net.NetworkCredential("yourgmaid", "yourgmailpassword");
SMTPServer.EnableSsl = true;
SMTPServer.Send(MyMailMessage);
After that you can check your attachment code.
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
I am trying to read a sql database so the same rows will not be inserted. I already got the connection I just need to know how to not insert the same row twice. I am using the VB language. Any ideas?
|
|
|
|
|
jds1207 wrote: so the same rows will not be inserted
so u don`t wan`t to insert anything...
jds1207 wrote: I just need to know how to not insert the same row twice
But now you are saying u need to insert it twice....
Pls be a bit more clear every time u post a question, otherwise u ll keep howling like a donkey...
|
|
|
|
|
This is how I am trying to get it. For example, If I insert a row into the database that have a department name HR and a username user.name and I try to insert another row that has the same department and username, the new row can't be inserted because the department and username already exists.
|
|
|
|
|
You could first select the record you are trying to insert. If you get something back, then you know it already exists.
I would also recommend that you research using a DataAdapter object which, if setup correctly, can help a lot with inserting, updating, deleting, etc. You could start your research with some of these articles.[^]
Hope this helps.
|
|
|
|